SQL Server debugging rights for standard developers

I guess it is not possible to debug开发者_开发百科 a query in SQL Server if the user is not granted with sysadmin rights, hence I get the Error 229. I understand that being a sysadmin for a developer is unacceptable (my DBA won't grant me that right for sure), so is there any kind of workaround for a developer to debug an SQL Server query without being granted as sysadmin? In my opinion, debugging in SQL Server should not be something that only sysadmins are allowed to do..

You must have syadmin rights in order to be able to debug SQL (see How to: Set SQL Server Permissions for Debugging)

Debugging SQL isn't something that should be done on production machines - in the words of Microsoft:

Debugging sessions often run for long periods of time while you investigate the operations of several Transact-SQL statements. Locks, such as update locks, that are acquired by the session might be held for extended periods, until the session has ended or the transaction is committed or rolled back.

Definitely not a good idea for production machines.

(I'm assuming that this was for a production SQL server - restricting permissions for devs on non production servers seems kinda pointless)

If you need to debug against on a production machine because of the live data then just do the debugging on a mirror / backup of the live data.

You only need execution rights (as far as I know) - I'm certainly no sysadmin but I can debug SQL