November 8, 2005 at 10:07 pm
When I start the debugger and press 'Execute'. The 'T-SQL Debugger' window appears, showing the procedure code. However, it does not show the 'Current Row' arrow. All the 'Step Into', 'Step over' .. and 'Restart' buttons are disabled (grey out). The only buttons available are 'Go', 'Toggle Breakpoints' and 'Remove All Breakpoints'.
I have made myself as the Administor. I have grant myself the 'EXEC' access to the SP_SDidebug. I have also set the DCOM permission settings (according to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servtools_5cfm.asp) in both the server and client boxes. But the problem still persists. What else do I need to do use the debugger properly?
Thanks in advance
James
November 10, 2005 at 8:25 am
I had a problem similiar to yours I believe. When I attempted to debug it would Execute rather than stepping into the code. This happened when I tried to debug from the client to database I was connnected to on the server.
The solution for my situation I found was that I was using an older version and had to update my service packs which included updates for my client tools. I updated to Service Pack 3a from the initial installation of SQL Server 2000. You may want to try verifying your service packs.
November 10, 2005 at 10:00 am
James,
John's correct - it is usually a version mismatch (probably MDAC, but I'm not sure). For example, when I installed SP 4 on my servers, I didn't apply it to my desktop (i.e. the client tools). I had the same problem with the debugger as you have. Ran SP 4 on my desktop, and the problem was resolved.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply