I am trying to test some query so i tried running it inside of SQL enterprise manager and i get the following error:
EXECUTE permission denied on object 'sp_enable_sql_debug', database 'mssqlsystemresource', schema 'sys'.
any suggestions?
A:
Your case seems to be a simple question of permissions - if you can't even execute your code, you can't debug it.
Once you can execute your code and still run into problems, SQL Server 2008 does offer a T-SQL debugger inside SQL Server Management Studio.
Quite useful if you need to debug complicated T-SQL script batches or stored procs!
Marc
marc_s
2009-07-19 12:07:57
+2
A:
You have to be a member of the sysadmin role to run this system stored proc to enable debugging.
This is different to having permissions to run your code which you created in your database
More info from a blog entry from the "CLR Integration team at SQL Server"... Skip to 3rd paragraph if you have short attention span about why sysadmin rights are needed
gbn
2009-07-19 13:25:23