How do you turn on debugging

  • How do you activate debugging in query analyzer - SQL 2000 - SP3a?  The client is running Windows XP, SP2 with SQL Server 2000 SP3

    When I set stop points in a stored procedure - nothing happens - the SP just completes normally. 

    I found an article indicating that the following command must be run - Exec sp_sdidebug 'legacy_on' .  After turning on legacy mode, I get the message:

    Server: Msg 504, Level 16, State 1, Procedure sp_sdidebug, Line 1

    [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on SQLSERVER1 (Error = 0x800706ba). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on WORKSTATION1. Debugging disabled for connection 80.

    I'm not sure where to go from here - any thoughts would be welcome!

    Regards,

    Harley

     

  • Is the SQL Server running as an adminsitrative account on the server? I think that is an issue. Hard to remember since I haven't used this in a long time.

    It seems to me that it's a security thing, but I'm not sure.

  • Steve,

    Sorry but I don't know - the servers are all outsourced to a large third-party - fortunately I have been able to at least retain sa rights on DEV and QA boxes but have no rights at the OS level on the servers.

    Any thoughts about how to work around the problem - we have some complex SPs and it would greatly simplify development and testing if I could use the debugger.

    Thanks,

    Harley

     

  • Did you try to run the stored procedure debug on the local machine?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply