Create a new service (a task or set of tasks). Service Broker will use the name of the service to route & deliver messages.
Syntax CREATE SERVICE service [AUTHORIZATION owner] ON QUEUE [schema.]queue [(contract | [DEFAULT] [,...n])] [;] Key service The service to create. owner A database user or role queue The queue that receives messages for this service contract A contract for which this service may be a target DEFAULT A valid target for DEFAULT contract conversations
Each service may be a target for one (or more) contracts, each of these will expose functionality to other services.
CREATE SERVICE [//ss64.com/Demo]
ON QUEUE [dbo].[DemoQueue]
"Every man has a right to risk his own life for the preservation of it" - Jean Jacques Rousseau, The Social Contract
© Copyright SS64.com 1999-2013
Some rights reserved