本文介绍了如何在触发器打开和关闭时检查日志的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 亲爱的, 我创建了一个触发器,只要特定列发生变化,就会将条目插入到新表中。但是我收到了客户的投诉,称没有为日志表中的所有更新记录维护日志。我觉得可能是由于触发器在更新某些记录时被关闭所以它可能没有被记录在日志表中。 我想检查我的触发器是什么时候在SQL Server 2005数据库中打开和关闭。 SQL Server是否保留触发器开/关事件的日志?如何查看触发器是打开还是关闭的日志记录? 提前致谢。解决方案 Dear all, I have created a trigger which inserts entry into new table whenever there is change in specific column. But I received a complaint from client saying that log is not maintained for all updated records in Log Table. I feel it may be due to trigger is turned off while updating some records so it may not have been recorded in log table. I want to check when my trigger is turned On and Off in SQL Server 2005 database. Does SQL Server maintain log of Trigger On/Off events? How to see log record of whether Trigger is Turned On or Off?Thanks in advance. 解决方案 这篇关于如何在触发器打开和关闭时检查日志的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
05-28 21:31
查看更多