审核SQL Server中的试用版以跟踪表中的更改 [英] Audit trial in sql server to track changes in the table

问题描述

亲爱的朋友，
我要求您将逻辑或源代码发送到sql server中的审计跟踪.
每当对关键形式进行一些更改时，都应该有一个痕迹.这将有助于公司不时了解所做的更改.通过此审计跟踪表单可以跟踪这些更改.

审核跟踪应将以前的数据和当前数据(修改后的数据)以及修改后的用户，时间，日期等作为主体....

Dear Friend,
I request you to send the logic or source code for audit trail in sql server.
Whenever some changes are made in the critical forms, there should be a trail for it. This will help the company know the changes made from time to time. The tracking of these changes would be through this Audit trail form.

Audit trail should main the previous data and current data (modified data) along with the modified user, time, date etc....

推荐答案

上一个项目是在存储过程中插入一个脚本，该脚本将插入到审计跟踪表中.因此，如果您使用存储过程，则此逻辑可能会起作用.

What I did in my previous project was to insert a script on the stored procedures that will insert to the audit trail table. So if you are using stored procedures, this logic might work.

在CP中找到了这些文章

用于Microsoft SQL的审核跟踪生成器 [使用触发器实施审计跟踪 [审核跟踪–跟踪数据库中的数据更改 [使用原型模式实施审核/历史跟踪 [使用实体框架实施审核跟踪-第1部分 [使用实体框架实施审核跟踪-第2部分 [

Found these articles in CP

Audit Trail Generator for Microsoft SQL[^]
Implementing Audit Trail using Trigger[^]
Audit Trail – Tracing Data Changes in Database[^]
Implementing Audit / history tracking using Prototype Pattern[^]
Implementing Audit Trail using Entity Framework - Part 1 [^]
Implementing Audit Trail using Entity Framework - Part 2[^]

这篇关于审核SQL Server中的试用版以跟踪表中的更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！