Microsoft® SQL Server™ administration can be a complex task. Realistically, an administrative application guides users, streamlining tasks and limiting the range of possible errors. Nonetheless, errors can occur and a SQL-DMO application should supply error handling code to prevent abnormal termination.
Microsoft Visual Basic®/ActiveX® script supports error traps (error handlers) created using the On Error statement. SQL-DMO supports the Visual Basic Err object, allowing application error handlers to respond intelligently to errors raised.
Note Error handling in your OLE Automation controller may differ from that described earlier. For more information about error handling, see your OLE Automation controller documentation.