471,079 Members | 976 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,079 software developers and data experts.

T-SQL Debugger Error

Hi,

When I debug our sp by using T-SQL Debugger, I got following error.

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'.
and when I grant the permission of sp_sdidebug, I got following error.

Server: Msg 4610, Level 16, State 1, Line 1
You can only grant or revoke permissions on objects in the current
database.
I am using following statement to grant the permission.

GRANT EXECUTE
ON sp_sdidebug
TO myuser

Here, I want to clear, myuser is I, which one i log QA.
and myuser has public and dbowner permission

--
Rahul

Apr 25 '07 #1
2 4638
"Rahul" <ve**********@gmail.comwrote in message
news:11*********************@r30g2000prh.googlegro ups.com...
Hi,

When I debug our sp by using T-SQL Debugger, I got following error.

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'.
and when I grant the permission of sp_sdidebug, I got following error.

Server: Msg 4610, Level 16, State 1, Line 1
You can only grant or revoke permissions on objects in the current
database.
I am using following statement to grant the permission.

GRANT EXECUTE
ON sp_sdidebug
TO myuser

Here, I want to clear, myuser is I, which one i log QA.
and myuser has public and dbowner permission

--
Rahul

Apr 25 '07 #2
"Rahul" <ve**********@gmail.comwrote in message
news:11*********************@r30g2000prh.googlegro ups.com...
Hi,

When I debug our sp by using T-SQL Debugger, I got following error.

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'.
and when I grant the permission of sp_sdidebug, I got following error.

Server: Msg 4610, Level 16, State 1, Line 1
You can only grant or revoke permissions on objects in the current
database.
Correct. sp_sdidebug is in the master database and you're most likely in a
different database.

Generally user written stored procs should NOT have their names start with
sp_ because SQL Server handles those a bit differently (including basically
making them "publically" available from the master db.)

>
I am using following statement to grant the permission.

GRANT EXECUTE
ON sp_sdidebug
TO myuser

Here, I want to clear, myuser is I, which one i log QA.
and myuser has public and dbowner permission

--
Rahul


--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Apr 25 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by ziv | last post: by
3 posts views Thread by Ney André de Mello Zunino | last post: by
1 post views Thread by ziv | last post: by
reply views Thread by Kevin Jackson | last post: by
3 posts views Thread by Lou | last post: by
reply views Thread by Rahul | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.