SERVICE BROKER | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


i want to know what is service broker and what is relation between service broker and sql server
SQL Server Service Broker(SSB) is a new part of the database engine that is used to build reliable, asynchronous, message-based distributed database applications. Service Broker allows these applications to concentrate their development efforts on the issues of the problem domain in which they are going to be used. For complete aricle: CanadaDBA
Service Broker is introduced iN SQL server 2005.
Event notifications differ from triggers by the fact that the actual notification does not execute any code. Instead, information about the event is posted to a SQL Server Service Broker (SSB) service and is placed on a message queue from where it can be read by some other process. Check in SQL Server 2005 forum section for further information on enhancements. (moved from General DbA section) Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.