Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ramnadh
Starting Member
23 Posts |
 Posted - 2004-05-08 : 03:01:19
|
| HiI am unable to debug the stored procedure in SQL Server 2000. When i do right click on the Stored Procedure and Click Debug by giving the parameters it is just returning the value. It is not holding to debug the entire Stored procedure. Can any one help me.Ramnadh |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Ramnadh
Starting Member
23 Posts |
Posted - 2004-05-08 : 03:59:32
|
| Hi,Thanks for the reply.Just now i got the solution. The problem is that 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, the debugging cannot be done because 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'to know more about this refer this linkhttp://support.microsoft.com/?kbid=328151Ramnadh |
 |
|
|
|
|
|
Debugging Stored Procedure
Tara