Centralized Asynchronous Auditing with Service Broker
My article about Service Broker fundamentals and simple practical use has been posted on SQLTeam.com. Go check it out.
Service Broker is a new feature in SQL Server 2005. It is an integrated part of the database engine and it provides queuing and reliable direct asynchronous messaging between SQL Server 2005 instances only. In the future this is planned to be extended to non-SQL Server instances. This article shows how to use Service Broker and triggers to capture data changes.
More here.