November 22, 2006 at 4:52 pm
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
November 23, 2006 at 10:10 am
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.
November 24, 2006 at 12:44 pm
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
November 24, 2006 at 5:34 pm
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