Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Meow
Starting Member
8 Posts |
 Posted - 2006-01-25 : 12:51:27
|
| I tried to debug a sp and got this message:Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.My sys admin probably knows less than I do, should i send him this msg and ask for permissions on the sp_ ?How can i explain to him what that sp_ is? |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-01-25 : 13:40:55
|
| does execute permission granted on that sp by calling user in context..also this problem comes from the Project Properties setting "Enable SQL Debugging" being set to true. Disable that setting, and it should work fine. |
 |
|
|
Meow
Starting Member
8 Posts |
Posted - 2006-01-25 : 14:18:24
|
| I dont know what you mean by execute permissions granted on the spWhere do i find project properties in QA or Ent manager. I just started studying SQL Serv 3 days ago |
|
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-01-25 : 14:31:40
|
| right click on that sp in Ent Manager, click on permissions tab on the upper right hand corner and make sure you have granted execute permission to your user account (execute checkbox is checked)..The following refers refers to Visual Studio.net UI and ignore it in your case this problem comes from the Project Properties setting "Enable SQL Debugging" being set to true. Disable that setting, and it should work fine. |
|
|
|
Meow
Starting Member
8 Posts |
Posted - 2006-01-25 : 14:43:21
|
| I dont even see that sp in the master table sp section i went to QA and and did an object search and didnt see it there either.I am using Vs2005 now, so if i want to debug in there i would set SQL Debug to false? that seems backwards |
|
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-01-25 : 15:15:01
|
| open your master database and look into extended stored procedureshttp://support.microsoft.com/kb/328173/In Transact-SQL Debugging, you cannot debug stored procedures that you do not own after you install SQL Server 2000 Service Pack 3 (SP3). |
|
|
|
|
|
|
|
|
Permissions on debuging?