Debug Executes instead of Steps

Question

Debug Executes instead of Steps

dean gross

SSCrazy

Points: 2632
More actions
September 15, 2005 at 6:56 am

#91294

My co-worker can not debug a sproc. When he tries to the sproc executes instead of stepping through. This happens in several development DBs. I can debug the same sprocs from my pc without any problems..
The server is Win 2000 with SQL Server 2000, w/SP4. Both of us have Windows XP SP-2. Any suggestions as to what might be causing this?

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

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

dougjjj SSCrazy Points: 2081 More actions · Answer 1

I've had this one a couple of times, it's to do with permissions of the account the debugging process service is running from, have a search on google for it, I originally found it on there, I'll have a quick look and see if I can track it down again.

dougjjj SSCrazy Points: 2081 More actions · Answer 2

Also check Remote Procedure Call (RPC) & Remote Procedure Call (RPC) Locator services are running and what user they are set to run as.

dean gross SSCrazy Points: 2632 More actions · Answer 3

Thanks for the suggestion, however, it turns out he did not have SQL Server SP4 like the server does. After upgrading his client tools the problem was fixed. Hope this helps others with the same problem.