What is the Service Broker Identifier

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

(Continued from previous question...)

What is the Service Broker Identifier

Answer
A GUID that identifies the database on which Service Broker is running.

Explanation
Each database has a Service Broker identifier. This is a GUID in the service_broker_GUID column that identifies the databases on which Service Broker is running. It ensure that messages are delivered to the right database.

(Continued on next question...)

Other Job Interview Questions

• Which of these options cannot be set in the SQL Server 2005 Integration Services Bulk Insert task?
• In SQL Server 2005 Full-Text Search, you set up a replacement set like this...
• What type of connectivity does the readpipe/makepipe utility test?
• What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• Which table would you query in your report to get logging information about a job step?
• In which order do you perform an upgrade to SQL Server 2005 for replicated databases?
• Which query will return a list of the synonyms in your database?
• What does CONTINUE do in T-SQL?
• What is one of the downsides of using RAID 5 as opposed to RAID 1?
• More...