CREATE SERVICE

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.

Example

CREATE SERVICE [//ss64.com/Demo]
ON QUEUE [dbo].[DemoQueue]
([//ss64.com/Demo/DemoSubmission]) ;

"Every man has a right to risk his own life for the preservation of it" ~ Jean Jacques Rousseau, The Social Contract

Related commands:

ALTER SERVICE
DROP SERVICE


© Copyright SS64.com 1999-2014
Some rights reserved