I want to debug a stored procedure in SQL Server 2008 r2, but when I debug it, a specific message is displayed. ie
Could not start debuggerADDITIONAL INFORMATION:EXECUTE permission was denied to 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
Could not start debugger
ADDITIONAL INFORMATION:
EXECUTE permission was denied to 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 anyone has any solution, thanks
Debugging SQL requires sysadmin .
See Error in more detail : the user was unable to execute the sp_enable_sql_debug stored procedure and How to set SQL Server permissions for debugging