Configuration for debugging stored procedure

Question

I want to debug a stored procedure in SQL Server 2008 r2, but when I debug it, the specific message is displayed.i.e

Failed to start debugger

ADDITIONAL INFORMATION:

The EXECUTE permission was denied on the object 'sp_enable_sql_debug', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476

Please tell me if anybody has some solution, Thanks

Jon Schneider · Accepted Answer · 2014-07-09 20:32:26Z

7

SQL Debugging requires sysadmin permission.

Read more at Error: User Could Not Execute Stored Procedure sp_enable_sql_debug and How to: Set SQL Server Permissions for Debugging

edited Jul 9, 2014 at 20:32

Jon Schneider

27.2k25 gold badges158 silver badges183 bronze badges

answered Jan 3, 2012 at 11:07

Stefan

5,6624 gold badges28 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JohnC Over a year ago

Please vote on Microsoft Connect for a resolution to this issue, MSIT-MSO: Debugging SQL Query fails with an error The EXECUTE permission was denied on the object 'sp_enable_sql_debug' (ID: 351698)

Collectives™ on Stack Overflow

Configuration for debugging stored procedure

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related