Events (SQL-DMO)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Some SQL Distributed Management Objects (SQL-DMO) objects support events. OLE object events provide a callback mechanism, and SQL-DMO uses events to signal an application conditionally.
SQL-DMO applications can handle raised events to provide intelligent interaction with the user during long-running processes and to handle abnormal conditions.