What is Service Broker in SQL Server ?

Service Broker is a message-queuing technology in SQL Server that allows developers to integrate SQL Server fully into distributed applications. Service Broker is a feature that provides a facility to SQL Server to send an asynchronous, transactional message.

It allows a database to send a message to another database without waiting for the response; so the application will continue to function if the remote database is temporarily unavailable.



You May Interest

Showing Server Active Server Name in MS SQL

MS SQL List of Records in All Tables

Using MS SQL COUNT

How to Optimize Stored Procedure in SQL Server ?

What is the Filtered Index in SQL Server ?