I recently posted a question looking to find an alternative to granting devs
sysadmin privileges just to use the sql server debugger. I am finding that there really isn't a feasible solution to this.
My question here is, WHY does the sql server debugger require sysadmin privileges? I want to understand the reasons behind designing it this way.
In a dev environment, developers should be able to do dev activities such as using the built-in debugger tools without granting sysadmin, instead of being told to basically build his own debugging mechanism using print statements, etc.
SQL server has privileges for so many specific roles/tasks, etc, it's odd not to see a separate one for this e.g. which could be granted only in a dev environment, etc.
I don't think this question is a duplicate of the others, since this question is not about how to use the debugger if you aren't a sysadmin, but rather, it is so I can understand why it is designed this way.