Discussion in 'SQL Server 2005 General DBA Questions' started by B5CSE, Nov 29, 2004.
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
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)
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Separate names with a comma.