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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.