What does the CREATE SERVICE statement do in SQL Server 2005?
Answer
This statement is used to setup new tasks for Service Broker queues.
Explanation
This statement is ue to create a new Service Broker service that is a set of tasks that are run on messages.