Debugging when developing a website with vs2008 Code (Select the method attached to the process for debugging), the following error is reported when executing an SQL query:
"/Vm" Application Program Server error.
The execute permission on the object 'SP _ sdidebug' (Database 'master', owner 'dbo') is denied.
Note:An error occurred while executing the current Web request. Check the stack trace information for details about the error and the source of the error in the code.
Exception details:System. Data. sqlclient. sqlexception: The execute permission on the object 'SP _ sdidebug' (Database 'master', owner 'dbo') is denied.
Source error:
Line 116: dscommand. selectcommand. commandtext = SQL; row 117: dscommand. selectcommand. commandtype = commandtype. text; row 118: dscommand. selectcommand. connection. open (); row 119: Try row 120 :{
|
Source file:D: \ work \ VM \ sqlserverdal \ sqllink. CSRow:118
Stack trace:
[Sqlexception (0x80131904): The execute permission on the object 'SP _ sdidebug' (Database 'master', owner 'dbo') is denied.] System. data. sqlclient. sqlconnection. onerror (sqlexception exception, Boolean breakconnection) + 1948826 system. data. sqlclient. sqlinternalconnection. onerror (sqlexception exception, Boolean breakconnection) + 4844747 system. data. sqlclient. tdsparser. throwexceptionandwarning (tdsparserstateobject stateobj) + 194 system. data. sqlclient. tdsparser. run (runbehavior, sqlcommand cmdhandler, sqldatareader datastream, bulkcopysimpleresultset bulkcopyhandler, tdsparserstateobject stateobj) + 2392 system. data. sqlclient. sqlcommand. finishexecutereader (sqldatareader ds, runbehavior, string resetoptionsstring) + 204 system. data. sqlclient. sqlcommand. runexecutereadertds (commandbehavior describehavior, runbehavior, Boolean returnstream, Boolean async) + 954 system. data. sqlclient. sqlcommand. runexecutereader (commandbehavior describehavior, runbehavior, Boolean returnstream, string method, dbasyncresult result) + 162 system. data. sqlclient. sqlcommand. internalexecutenonquery (dbasyncresult result, string methodname, Boolean sendtopipe) + 175 system. data. sqlclient. sqlcommand. executenonquery () + 137 system. data. sqlclient. sqlconnection. issuesqldebug (uint32 option, string machinename, uint32 PID, uint32 ID, string sdidllname, byte [] data) + 561 system. data. sqlclient. sqlconnection. checksqldebug (sqldebugcontext SDC) + 129 system. data. sqlclient. sqlconnection. checksqldebugonconnect () + 349 system. data. sqlclient. sqlconnection. completeopen () + 4874985 system. data. sqlclient. sqlconnection. open () + 185 VM. sqlserverdal. sqllink. selectsqlset (string SQL) in D: \ work \ VM \ sqlserverdal \ sqllink. CS: 118 VM. sqlserverdal. baseentity. clscity. load_homeoftencity () in D: \ work \ VM \ sqlserverdal \ baseentity \ clscity. CS: 452 VM. VM. business. hotel. searchguonei. bindchangqucity () in D: \ work \ VM \ WEB \ business \ hotel \ searchguonei. aspx. CS: 39 VM. VM. business. hotel. searchguonei. page_load (Object sender, eventargs E) in D: \ work \ VM \ WEB \ business \ hotel \ searchguonei. aspx. CS: 30 system. web. util. callihelper. eventargfunctioncaller (intptr FP, object o, object T, eventargs e) + 14 system. web. util. callieventhandlerdelegateproxy. callback (Object sender, eventargs e) + 35 system. web. UI. control. onload (eventargs e) + 99 system. web. UI. control. loadrecursive () + 50 system. web. UI. page. processrequestmain (Boolean includestagesbeforeasyncpoint, Boolean includestagesafterasyncpoint) + 627
|
Version:Microsoft. NET Framework Version: 2.0.50727.3053; ASP. NET version: 2.0.50727.3053
Baidu provides the following solutions:
When called in. net, the following error occurs: "The execute permission to the object 'SP _ sdidebug' (Database 'master', owner 'dbo') is denied.
This problem occurs when I start the project with the specified URL and then "append the process" to run the 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 "select" after "attach to:". The default option is "automatically determine the code type to debug ". 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.
