Create Queue SQL Server 2012

Create Queue SQL Server 2012

Create Queue SQL Server 2012

-- =============================================
-- CREATE QUEUES FOR SERVICE BROKER
-- =============================================
CREATE QUEUE <QUEUE-NAME, SYSNAME, TEST_QUEUE>
   WITH
   STATUS = ON,
   RETENTION = OFF ,
   ACTIVATION (
              STATUS = ON,
              PROCEDURE_NAME = <PROC-NAME, SYSNAME, TEST_PROCEDURE> ,
              MAX_QUEUE_READERS = <MAXREADERS, INT, 1>,
              EXECUTE AS <EXECUTE-OPTIONS,,SELF> ),
   POISON_MESSAGE_HANDLING (STATUS = ON)
   ON <FILEGROUP,,[DEFAULT]>

-- =============================================
-- CHECKING QUEUES
-- =============================================
SELECT * FROM SYS.SERVICE_QUEUE_USAGES



ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Buy Books Online at Best Prices

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.