Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Cannot debug stored procedures because the SQL Server database is not setup correctly or user does not have permission to execute master.sp_sdidebug.

SQL Server 2005

When debugging stored procedures, the debug process fails if a SQL Server login user does not have Execute permission granted to the extended stored procedure sp_sdidebug in the master database.

To debug stored procedures, you need to have appropriate user permissions to execute the extended stored procedure sp_sdidebug. The default access is for system administrators only.

This error can also occur if the SQL Server database debugging software (both server-side and client-side) is not setup correctly.

  1. Ask the database administrator for permissions to run the extended stored procedure sp_sdidebug.

Community Additions

© 2015 Microsoft