ERROR:
User ‘dbo’ could not execute stored procedure ‘master.dbo.sp_enable_sql_debug’ on SQL Server
EXPLANATION:
You may experience this error if you try to debug a Stored Procedure in SQL Server 2008.
SOLUTION:
To debug Stored Procedures in SQL Server 2008, you must be a member of “sysadmin” Server Fixed Role.
