Disable SQL Debugging in Visual Studio 2005

Hot Topic

NT Users Filter
multithreading
Time Passed
What database are you using?
How can I show the line that seperate mothods in C# (Like VB.NET)
Reading the end of an XML file
How Can I Create File or Folder on [Map Network Drive] ??
Spell Checker using word.
Programatically check if object implements the IList interface
Get OS Service Pack

Visual C#

PInvoke changes
Unhandled Exception in Debugging, Run OK in Starting without Debugging?
Cannot modify the return value of 'test.getinfo.UserInfo' because it is not a variable
Invalid Resx file. A strongly-named assembly is required.
How to write Debug directive in CS file?
Hide/Show form while retaining Info
Accessing files/directories with different permission
how to display the applications running on the system??
using thread with static object ?
[C#]conversion from time to double

Disable SQL Debugging in Visual Studio 2005

Hi,
When stepping through code which indirectly talks to a database we are getting the following error
"Execute Permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'
The IDE is Visual Studio 2005 and I have looked at the project settings and 'Enable SQL Server Debugging' is not checked. I would like to understand why I am getting the error inspite of this and what I need to do to disable this.
FYI - Giving permission to execute the SP is not an option.
Thanks
Vidya

Answer this question

Disable SQL Debugging in Visual Studio 2005

  • Joffies

    Me three. Can't seem to track this down. No projects have SQL Debugging turned on, but keep getting this exception.

  • Arghya

    Figured it out. In the "Attach to process" dialog, change the "Attach to" setting to just managed code. Looks like it selects TSQL by default.

  • AndrejJst

    Have you got any solution or ways around the problem yet I am in exactly the same situation right now.

    Thanks.
  • Disable SQL Debugging in Visual Studio 2005
Answer this question