Introducing Event Notifications
Event notifications send information about events to a service broker service. Event notifications can be programmed against many of the same events captured by SQL Trace. But unlike creating traces, event notifications can be used to perform an action inside an instance of SQL Server 2005 in response to events. Because event notifications execute asynchronously, these actions do not consume any resources defined by the immediate transaction.