Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Enabling SQL Debugging on SQL 2000 Desktop Engines

To enable debugging of stored procedures on the SQL 2000 Desktop Engine, you must perform the following steps on the machine where the SQL 2000 Desktop Engine is installed.

To enable debugging with the SQL 2000 Desktop Engine (on a machine with Visual Studio .NET installed)

  1. Copy the MSSDI98.DLL from the Microsoft Visual Studio .NET 2003\sqlserver directory to the \binn directory.

To enable debugging with the SQL 2000 Desktop Engine (on a machine without Visual Studio .NET)

  1. Locate MSSDI98.DLL on the Visual Studio .NET CD or DVD and copy it to the \binn directory.
  2. Locate SQLDBG.DLL on the Visual Studio .NET CD or DVD and copy it to:
    program files\common files\microsoft shared\sql debugging
    
  3. Reregister SQLDBG.DLL by entering the following command at the Command Prompt:
    regsvr32 sqldbg.dll
    
  4. Grant execute permission on the stored procedure sp_sdidebug to the debugger user:
    GRANT EXECUTE
    ON sp_sdidebug 
    TO myUserName  
    

See Also

Setting Up SQL Debugging | Debug Settings and Preparation | Debugging SQL | System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.