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

Answer 1

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