Msg 537，Level 16，State 2，Procedure t_DDLAudit，Line 23 [Batch Start Line 0] [英] Msg 537, Level 16, State 2, Procedure t_DDLAudit, Line 23 [Batch Start Line 0]

问题描述

您好，尝试给予批准并收到错误消息：

Hello , trying to give grant and recieving the error msg :

消息537，级别16，状态2，过程t_DDLAudit，行23 [批处理开始行0]

Msg 537, Level 16, State 2, Procedure t_DDLAudit, Line 23 [Batch Start Line 0]

命令：

将GPARAMS选择为sysdba;

GRANT SELECT ON GPARAMS TO sysdba ;

谢谢。

Rodrigo S. Nascimento

Rodrigo S. Nascimento

推荐答案

首先，我怀疑错误消息比您发布的消息更多。大多数人没有记住sql server生成的每个错误号 - 所以请分享有关错误的一切。

First, I suspect there is more to the error message than what you post. Most people have not memorized every error number generated by sql server - so please share everything about the error.

错误消息告诉您名为"t_DDLAudit"的DDL触发器中存在逻辑错误。 - 有人需要修理它。 

The error message is telling you that there is a logic error in the DDL trigger named "t_DDLAudit" - someone needs to fix it. 

这篇关于Msg 537，Level 16，State 2，Procedure t_DDLAudit，Line 23 [Batch Start Line 0]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！