The execute permission on the object 'SP _ sdidebug' (Database 'master', owner 'dbo') is denied.

"The execute permission on the object 'SP _ sdidebug' (Database 'master', owner 'dbo') is denied."

.

This problem occurs when I start the project with the specified URL, and then run the "APPEND process" command.Program. This problem mainly occurs. due to net2005's debugging mechanism, after a program has been started and a process has been attached, it is required to debug the SQL Server by default. This requires patches to be installed for support. Therefore,"The execute permission on the object 'SP _ sdidebug' (Database 'master', owner 'dbo') is denied.. In this case, we can change the debugging type to solve the problem and make debugging normal.

In the "attach to process" dialog box, click the "select" button after "attach to:". The default option is "automatically confirmCodeType ". Select "debug the following code" and select "managed" only ". In this way, you can proceed normally.

In addition, if debugging cannot be started for the project as a whole, you can specify a URL for debugging in the project, after the process is started, you can use the above method to attach the process to the debugger to debug the project.