Scenarios

Service Broker enables a whole new class of reliable, asynchronous, database applications that could not easily be built before. With all the talk about transactional messaging, it’s easy to get the impression that Service Broker is just another reliable messaging product. Although Service Broker offers unprecedented levels of reliability, availability, and performance as a transactional messaging platform, it is also extremely useful in applications that have nothing to do with networking and distribution. People often start out using Service Broker for reliable messaging and end up using it for everything from asynchronous stored procedures to batch scheduling. In this section, I’ll cover a few scenarios where Service Broker provides ...

Get Inside Microsoft® SQL Server™ 2005 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.