More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What value should you use for the BROKER_INSTANCE parameter?
You need to create a route for your SQL Server 2005 Service Broker queue. The messages should go to the SalesOrder queue on the Sales server. When you are creating the route, what value should you use for the BROKER_INSTANCE parameter?
Answer: It is the GUID of the Service Broker instance running in the target database.
Explanation: The BROKER_INSTANCE parameter is looking for the guid of the particular Service Broker instance in the target database. This value can be retrieved by running this query:
SELECT service_broker_guid
FROM sys.databases
WHERE database_id = DB_ID()
(Continued on next question...)