Hi All, I want to know what is the role of the service broker in Sql server services. What SQL server dependcies on Sql servce Broker. What is the feature that service broker adds to sqlserver Thaks, Gatham
Hi Gatham look at this article http://www.sql-server-performance.com/articles/dev/service_broker_p1.aspx
Also: http://msdn2.microsoft.com/library/ms345108.aspx internal or external SQL Server instances can send and receive guaranteed, asynchronous messages by using Transact T-SQL. Messages can be sent from within the same database, different database, or even remotely located SQL Server instances. http://www.codeproject.com/dotnet/IntroServiceBroker.asp too
[quote user="r_gautham2001"] Hi All, I want to know what is the role of the service broker in Sql server services. What SQL server dependcies on Sql servce Broker. What is the feature that service broker adds to sqlserver Thaks, Gatham [/quote] Here is the blog of the "father of Service Broker": http://blogs.msdn.com/rogerwolterblog/