Object Events

Some SQL-DMO objects support events. Automated OLE object events provide a callback mechanism and SQL-DMO uses events to signal an application conditionally. The SQL-DMO application can handle raised events to provide intelligent interaction with the user during a long-running process and to handle abnormal conditions. For example:

• The PercentComplete event of a Backup object informs the application of backup progress. The application can use the callback to update a progress control or check for a user action, such as a request for cancellation.
• The ConnectionBroken event of a SQLServer object informs the application that the network connection between the client and a server running Microsoft® SQL Server™ has been lost. The application could notify the user and prompt for authorization information for a reconnection attempt.