Home SQL Server Commands
 

ALTER SERVICE

Change a service (a task or set of tasks)

Syntax
      ALTER SERVICE service
         [ON QUEUE [schema.]queue]
            [(ADD | DROP CONTRACT contract [,...n])]  [;]
	  
Key
   service     The service to create.
   queue       The queue that receives messages for this service
   contract    A contract for which this service may be a target

Each service may be a target for one (or more) contracts, each of these will expose functionality to other services.

Example

ALTER SERVICE [//ss64.com/Demo]
ON QUEUE [dbo].[NewQueue] ;

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

Related commands:

CREATE SERVICE
DROP SERVICE



Back to the Top

Simon Sheppard
SS64.com