April 27, 2006 at 7:25 am
I seem to be unable to debug Stored Procedures that are on a SQL 7 server using SQL 2000 client tools from another machine. I can debug SQL 2000 stored procedures no problem. It allows me to launch the debugger but will only let me execute, all other functions are greyed out.
My sql 7 server is as service pack 3 and the SQL 2000 ones are at service pack 4. Books online say that this should work, so I'm not sure what the problem is. Any ideas?
Thanks
Graham
April 28, 2006 at 11:41 am
try debugging from .NET ide, it worked for me
if .NET does not debug then connect the database in question from enterprise manager and then again attempt to debug using .NET. I know it sounds quirky but it works, i have tried this successfully on many computers
logging in as admin both on Win2000/XP as well as sqlserver helps, you could switch the servicelogin in controlpanel>services form mssqlserver to something other than localsystem
i assume that u have read all the pages at microsoft
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply