无需使用触发器即可在SQL中审核试用版 [英] Audit trial in SQL with out using Triggers

问题描述

亲爱的团队，

您能否告诉我如何在不使用触发器的情况下进行审核试用.
审核试用意味着在更新，插入和删除的情况下应跟踪存储在表中的数据.


谢谢和问候，
Narasimha Rao.

解决方案

如果您不使用触发器(为什么不这么做?)，则只需要使用存储的proc并编写您的审核跟踪到他们.

您可能会出现以下任何情况

1.修改您的SQL脚本以插入审核数据

2.尝试从SQL Server [>更多信息. ..]

3. SQL Server 2008具有内置功能，可以捕获更改的数据.通过使用更改数据捕获，您消除了昂贵的技术，例如捕获数据的用户触发器. [更多详细信息...]

Dear team,

Could you please tell me how to do the audit trial with out using the triggers.
Audit trial means the data which you store in the tables should track in case of update, Insert and Delete...


Thanks and Regards,
Narasimha Rao.

解决方案

If you don''t use triggers ( and why wouldn''t you ? ) then you need to only use stored procs, and write your audit trail in to them. How else can it work ?

Your might any of the followings

1. Modify your SQL scripts to Insert audit data

2. Try built-in C2 Audit Functionality from SQL Server [more details ...]

3. SQL Server 2008 has the inbuilt feature to capture the changed data. By using change data capture, you eliminate expensive techniques such as user triggers to capture the data. [more details ...]

这篇关于无需使用触发器即可在SQL中审核试用版的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！