Conclusion

Service Broker brings the advantages of asynchronous execution and reliable messaging to SQL Server applications. Service Broker’s message ordering, correlation, and activation features are unequaled by any messaging system. When combined with CLR integration, database mirroring, and the new XML features, Service Broker makes SQL Server 2005 a viable platform for building database applications and services that offer unprecedented levels of reliability and fault tolerance.

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.