SQL Server对标准开发人员的调试权限 [英] SQL Server debugging rights for standard developers

问题描述

如果用户没有被授予sysadmin权限，我猜测SQL Server中的查询是不可能的，所以我得到错误229.我明白，作为开发人员的系统管理员是不能接受的（我的DBA不会授予我肯定权利），所以有什么样的解决方法，开发人员调试SQL Server查询而不被授予sysadmin？在我看来，SQL Server中的调试不应该只是允许系统管理员做的事情。

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..

推荐答案

你必须具有syadmin权限，以便能够调试SQL（请参阅如何：设置调试的SQL Server权限）

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

调试SQL不是在生产计算机上应该完成的事情 - 以Microsoft的话：

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

当调查几个Transact-SQL语句的操作时，调试会话经常运行很长时间。会话获取的锁（例如更新锁）可能会持续较长时间，直到会话结束或交易提交或回滚。

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.

（我假设这是一个生产SQL服务器 - 非生产服务器上的开发人员的限制权限似乎没有意义）

(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.

这篇关于SQL Server对标准开发人员的调试权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！