DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 328151 - Last Review: February 27, 2014 - Revision: 6.4

This article was previously published under Q328151
This article has been archived. It is offered "as is" and will no longer be updated.

SUMMARY

By default, after you install Microsoft SQL Server 2000 Service Pack 3 (SP3), you cannot use the T-SQL Debugger if you are using a version of Query Analyzer that is earlier than Microsoft SQL Server 2000 SP3 or a version of Microsoft Visual Studio earlier than Microsoft Visual Studio .NET.

You may receive the following error message if you try to use the T-SQL Debugger from an earlier client:
Server: Msg 514, Level 16, State 1, Procedure sp_sdidebug, Line 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to communicate with debugger on [SQL Server Name] (Error = 0x80070005). Debugging disabled for connection 53.

MORE INFORMATION

Note Versions of Query Analyzer that are earlier than SQL Server 2000 SP3 and versions of Visual Studio that are earlier than Visual Studio .NET are referred to as "earlier clients" in this article.

Microsoft has disabled T-SQL Debugger for earlier clients for security reasons. To enable T-SQL Debugger for earlier clients, a member of the sysadmins server role, such as sa must explicitly enable debugging by running the following code:
        Exec sp_sdidebug 'legacy_on'
				
You must repeat this procedure whenever you restart the server. Microsoft does not recommend that you use T-SQL Debugger on a production server.

To disable T-SQL Debugger for earlier clients, a member of the sysadmins server role can run the following code:
       Exec sp_sdidebug 'legacy_off'
				

The following table describes the default behavior of Transact-SQL Debugger with SQL Server SP3.
Collapse this tableExpand this table
Debug ClientDefault'legacy_on'
Query Analyzer (pre-SP3)DisabledEnabled
Query Analyzer (SP3)EnabledEnabled
Visual Studio 5 and 6DisabledEnabled
Visual Studio .NET Direct Database DebuggingEnabledEnabled
Visual Studio .NET Application DebuggingDisabledEnabled

REFERENCES

For more information about T-SQL Debugger, see the "Using Transact-SQL Debugger" and "Troubleshooting the Transact-SQL Debugger" topics in SQL Server Books Online.

APPLIES TO
  • Microsoft SQL Server 2000 Service Pack 3
Keywords: 
kbnosurvey kbarchive kbproductlink kbinfo KB328151
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support