VS 2005 trying to debug SQL when I don't want it to

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Johnson - 09 Aug 2007 17:01 GMT

I'm getting the dreaded "EXECUTE permission denied on object 'sp_sdidebug',
database 'master', owner 'dbo'" error in a project but the Enable SQL Server
debugging check box is UNCHECKED in EVERY SINGLE PROJECT IN MY SOLUTION!!

WHY WHY WHY WHY WHY?

I have researched this error via Google Groups and everyone keeps saying
"uncheck this box." Well, it is and ALWAYS WAS unchecked, so why is VS
trying to execute sp_sdidebug?

If it helps any, I'm debugging a Windows service (and therefore I'm attached
to a process as opposed to having simply hit the Run button in VS).

Reply to this Message

Stevanich - 31 Aug 2007 17:48 GMT

Jeff,

I'm not sure about your error, but I find it best to develop and test
Windows Services as a class library or console app. Testing Windows
Services is no fun, as you've found out.

What process are you attaching to?

Hope this helps,

Steve

> I'm getting the dreaded "EXECUTE permission denied on object
> 'sp_sdidebug', database 'master', owner 'dbo'" error in a project but the
[quoted text clipped - 10 lines]
> attached to a process as opposed to having simply hit the Run button in
> VS).

Reply to this Message

Rate this thread:

VS 2005 trying to debug SQL when I don't want it to

Free Magazines