SQL Server Performance Forum – Threads Archive

SERVICE BROKER

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:http://www.sswug.org/see/20619 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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>