When you try to debug a stored procedure that you do not
own, you may receive following error 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'.
Back to the top
In Transact-SQL Debugging, you cannot debug stored
procedures that you do not own after you install SQL Server 2000 Service Pack 3
(SP3).
Back to the top
This
behavior is by design.
Back to the top
This behavior is a design change in SQL Server 2000 SP3 to
enhance security. This design change includes the following changes:
| • | A database users can only step into stored procedures that
they own. |
| • | A database owner (DBO) can debug any stored procedure in
the database that the DBO owns. (A DBO owns the database and, therefore, all
its stored procedures.) |
| • | Members of the SysAdmin server role can debug any stored procedure in any database on the
server. (A member of the SysAdmin server role owns the server and, therefore, all its
databases.) |
For more information about Transact-SQL Debugging, see the
"Using Transact-SQL Debugger" and "Troubleshooting the Transact-SQL Debugger"
topics in SQL Server Books Online.
Back to the top
Help and Support
