EXECUTE permission to object ' sp_sdidebug ' (Database ' master ', owner ' dbo ') was rejected __ database

"Deny EXECUTE permission on object ' sp_sdidebug ' (Database ' master ', owner ' dbo ') when called in. net

The wrong solution.

This problem occurs when I start the project with the specified URL and then run the program after "Attach process". This problem is mainly caused by the debugging mechanism of the. net2005, when the program is started and the process is attached, he defaults to debugging SQL Server, which requires a patch to support it. So there is an error of "EXECUTE permission on object ' sp_sdidebug ' (Database ' master ', owner ' dbo ')." At this point we can handle the problem by changing its debug type and make debugging work.

In the Attach to Process dialog box, click the Select button after attaching to: To see that the default option is to "automatically determine the type of code to debug." When you are finished, select debug the following code and select only "managed". This will be done normally.

In addition, if the project is not able to start debugging, you can also specify in the project from a URL for debugging, after the start of the above method to attach the process to the debugger can also achieve the debugging of the project.