Service Broker is message queuing for SQL Server. It is used for sending emails and through Database Mails. You can read about SQL SERVER – Difference Between Database Mail and SQLMail here. Service Broker is feature which provides facility to SQL Server to send an asynchronous, transactional message.
So how it works is SQL Server uses Service Broker to send message from database to message queue. This message is then picked up by different processes to send this message to its destination. This separate processes can be using SMTP protocol. Sending and receiving processes can be done using entirely different system or SQL Server instance. It is not required that both the services are online at the same time. Sending services or Receiving services both are not required to be on line at the same time.
In summary, Services Broker follows traditional client-server architecture. Here client service initiates a conversation and receiving services takes messages and processes to send it to its destination.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
[...] Above error comes up with Service Broker. Service Broker is used to send Database Emails. Read more about SQL SERVER – Introduction to Service Broker. [...]
[...] July 20, 2008 by pinaldave Just two day ago, I wrote small note about SQL SERVER – Introduction to Service Broker. [...]
[...] After all validations of the parameters entered are done, certain stored procedures are executed and the mail is queued by Service Broker, read more at SQL SERVER – Introduction to Service Broker. [...]
can i get a walk through of service broker
or else where can i get the examples of service broker implementation
[...] Service Broker is a message-queuing technology in SQL Server that allows developers to integrate SQL Server fully into distributed applications. Service Broker is feature which provides 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. (Read More Here) [...]
HI Pinal,
Nice Document given by you..
which may be very helpful in my project.
I have to fire automatic mail in project.
so thanks a lot for this doc…
[...] 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 which provides 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. (Read more here) [...]
hi, thanks for the great document, is it possible for me to send automated (daily)e-mails that gets the results of different stored procedures?