In SQL Server 2005, what does the CREATE SERVICE

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

(Continued from previous question...)

In SQL Server 2005, what does the CREATE SERVICE command do?

Answer: Adds a new Service Broker set of tasks.

Explanation: This command is used to create a new Service Broker service, or set of tasks. This name is used to route messages, deliver messages to a queue, and enforce the contract for a conversation.

(Continued on next question...)

Other Job Interview Questions

• You are wondering if your indexing scheme for the SQL Server 2005 database that you are managing is appropriate?
• you want to be sure that SQL authenticated logins must abide by the password policy.. .
• Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles
• Which of the following datatypes can be represented in a SQL_VARIANT datatype?
• What does this return? select (1324 & 1024)
• What does a report model provide in SQL Server 2005 Reporting Services?
• In replication, what is each set of the source data that is replicated from the source server called?
• What's the difference between a server login and a database user?
• What does HAS_DBACCESS() do?
• If you use the EXECUTE AS clause to impersonate a user at a database-scoped level...
• More...