Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
PRB: A Database User Cannot Debug Stored Procedures That Another User Owns
Article ID: 328173 - View products that this article applies to.
This article was previously published under Q328173
BUG #: 357336 (SHILOH_BUGS)
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'.
In Transact-SQL Debugging, you cannot debug stored procedures that you do not own after you install SQL Server 2000 Service Pack 3 (SP3).
This behavior is a design change in SQL Server 2000 SP3 to enhance security. This design change includes the following changes: