Microsoft® SQL Server 2012 Unleashed

Creating Queues for Message Storage

Queues represent a layer of communication indirection between services, allowing them to send and receive messages independently of each other. A queue is a first-class database object, internally implemented as a table that has some unique behaviors.

Note

You can select data from SSB queues using standard T-SQL SELECT syntax, for example: SELECT * FROM QueueName WITH (NOLOCK). This has no effect on the data in the queue, nor does it imply a message receive operation. It does, however, cause blocking on the internal queue table, so you should always use the NOLOCK hint. Data Manipulation Language (DML) statements on queues are not permitted.

The following is the syntax for creating a queue:

Click here to ...