Handling SQL-DMO Errors

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® or Microsoft ActiveX® scripts support 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 the OLE Automation controller documentation.