DBA > Job Interview Questions > Microsoft SQL Server FAQs

What does the CREATE SERVICE statement do in SQL

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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.

(Continued on next question...)

Other Job Interview Questions