Export (0) Print
Expand All
Expand Minimize
1 out of 14 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.