SQL Server Service Broker Question:

Do you know how to implement Service Broker?

SQL Server Service Broker Interview Question
SQL Server Service Broker Interview Question

Answer:

Using Transact SQL statements service broker can be used. An application can be implemented as a program running outside of SQL Server or as a stored procedure. Service broker uses a number of components to perform a task. A program that starts a conversation creates and sends a message to a service that may or may not respond. Any application that intends to use Service broker does not need any special object model or library. Transact-SQL commands to SQL Server can be sent for processing.


Previous QuestionNext Question
How to encrypt data between Dialogs?Explain what is the main purpose of having Conversation Group?