每次调用扩展过程时事件日志中都会出现 SQL Server 垃圾邮件
我在dll中编写了一个扩展存储过程。 每次我调用它时，SQL Server都会在Windows事件日志（Windows Logs\Application）中写入无用的“信息”：
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 04.09.2009
Time: 14:54:57
User: N/A
Computer: 4STORYTESTDB
Description:
8128 :
Using 'D:\AllProjects\mantainance\TBalanceSP.dll' version 'UNKNOWN' to execute extended stored procedure 'TGetAccountBalance'. This is an informational message only; no user action is required.
我经常调用这个过程，每秒10-20次。事件日志变成“zasrannym”（“充满 s..t”），正如我们在俄罗斯所说的那样。
如何禁用此日志消息？
I've wrote an extended stored procedure in dll.
Every time I call it, SQL Server wrote useless "Information" in Windows Event Log (Windows Logs\Application):
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 04.09.2009
Time: 14:54:57
User: N/A
Computer: 4STORYTESTDB
Description:
8128 :
Using 'D:\AllProjects\mantainance\TBalanceSP.dll' version 'UNKNOWN' to execute extended stored procedure 'TGetAccountBalance'. This is an informational message only; no user action is required.
I call this procedure very often, 10-20 times per sec. and Event Log becomes "zasrannym" ("full of s..t"), as we say in Russia.
How can I disable this log message?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
只是猜测，但可能是用于执行存储过程的帐户没有足够的访问权限来执行其本身或存储过程内的某些操作。这将是一个错误，我认为您更愿意修复该错误而不是隐藏它。 ;-)
Just a guess, but it could be that the account used to execute the stored procedure doesn't have enough access rights to execute itself or some action inside the stored procedure. This would be a bug and I think you'd prefer to fix the bug instead of hiding it. ;-)
在 SQL Server 2005 中，您可以使用“-n”启动参数控制 SQL 是否将事件记录到 Windows 应用程序日志中。
请参阅此链接以获取 MSDN 文档。
链接文本
In SQL Server 2005 you can control whether or not SQL will log events to the Windows Application Log with the "-n" startup parameter.
See this link for the MSDN Documentation.
link text