User ‘dbo’ could not execute stored procedure ‘master.dbo.sp_enable_sql_debug’ on SQL Server

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.