How can you determine which Service Broker ports

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

(Continued from previous question...)

How can you determine which Service Broker ports are being used on your server?

Answer
Query the system catalog view: sys.conversation_endpoints
Explanation
The system catalog view sys.conversation_endpoints will show you which Service Broker endpoints, and therefore ports, are open on your server.

(Continued on next question...)

Other Job Interview Questions

• You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?
• What's an allocation unit?
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• How does a differential backup know which extents have changed so that it can be very quickly run?
• What feature of SQL Server 2005 would help you get the snapshot transferred?
• A .NET assembly running with UNSAFE permissions can do which of the following?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
• Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control?
• Where are Notification Services event messages logged in SQL Server 2005?
• More...