Does debugging in SQL 2008 require sysadmin priviledges
I was asked a the London PASS usergroup meeting (http://www.sqlpass.org.uk/Events/September2009Meeting/tabid/59/Default.aspx)
if you could debug if you weren't sysadmin.
Unofrtunately you can't. Your SQL server users has to be a sysadmin user. You
can find this documented here http://msdn.microsoft.com/en-us/library/cc646024.aspx
However unlike the old debugger you had in Visual Studio I don't believe you
need admin access to the SQL Server. Which is a god thing.
By the way, I've tried hacking sp_enable_sql_debug to grant the correct
permissions but was unable to get it working. I fear this is an internal SP that
has the permission set defined internally
-