Queues store messages. When Service Broker receives a message for a service, Service Broker inserts the message into the queue for that service. To get messages sent to the service, an application receives messages from the queue. Service Broker manages queues and presents a view of a queue that is similar to a table.
Each service is associated with one queue. When a message arrives for a service, Service Broker places the message in the queue associated with that service.
Each message is a row in the queue. The row contains the content of the message as well as information about the message type, the service targeted by the message, the contract that the message follows, the validation performed on the message, the conversation that the message is a part of, and information internal to the queue. An application uses the information in the message row to identify each message uniquely and process the message appropriately.
Applications receive messages from the queue for the service. For each conversation, queues return messages in the order in which the sender sent the message. All the messages returned from a single receive operation are part of conversations that belong to one conversation group. In effect, a queue holds sets of related messages, one set for each conversation group. The queue returns one set of related messages each time the application performs a receive operation from the queue. The application can choose to receive messages for a specific conversation, or a specific conversation group. Queues do not return messages in strict first-in-first-out order; instead, queues return messages for each conversation in the order in which the messages were sent. Therefore, an application does not need to include code to recover the original order of the messages.
A queue may be associated with a stored procedure. In this case, SQL Server activates the stored procedure when there are messages in the queue to be processed. SQL Server can start more than one instance of the stored procedure up to a configured maximum. For more information, see Service Broker Activation.
Introduction to Service Broker Programming
CREATE QUEUE (Transact-SQL)
ALTER QUEUE (Transact-SQL)
DROP QUEUE (Transact-SQL)
Service Broker Activation
Choosing a Startup Strategy
Understanding When Activation Occurs
Creating Service Broker Queues