SQL Server 2008更改数据捕获，谁进行了更改？ [英] SQL Server 2008 Change Data Capture, who made the change?

问题描述

大约一周前，我在SOF上提出了一个有关审核SQL数据更改的问题。有关使用触发器的常见信息出现了，SQL Server 2008中也提到了CDC。

I asked a question on SOF a week or so ago about auditing SQL data changes. The usual stuff about using triggers came up, there was also the mention of CDC in SQL Server 2008.

我今天一直在尝试，到目前为止，我看不到它支持的一件事是跟踪谁真正进行了更改。谁执行了该语句？

I've been trying it out today and so far so good, the one thing I can't see it supports is keeping a track of who actually made the change. Who executed the statement?

我想知道是否有人使用CDC进行审计以及您如何跟踪谁进行了更改？

I'm interested to know if anyone has used CDC for auditing and how you kept track of who made the change?

推荐答案

更改数据捕获不会跟踪用户，进行更改的计算机或更改时间。

Change Data Capture doesn’t track the user, machine who made the change, or time of change.

跟踪CDC进行更改的用户的最佳解决方案是创建一个新字段来存储用户详细信息，该字段将在每次更改时进行更新（找到该主意此处）。

The best solution to track users who made the change with CDC is to create a new field to store users details, which will be updated on each change (found that idea here).

同一系列的另一篇文章将我引向第三方工具，提供了开箱即用的解决方案。我仍在评估过程中，但到目前为止看起来还不错。您可以在此续集。

Another article in the same series lead me to a third party tool offering an out-of-the-box solution. I’m still in evaluating process, but it looks quite good so far. You can see the comparison of tracked information in a handy table at the end of this sequel.

希望这会有所帮助。

这篇关于SQL Server 2008更改数据捕获，谁进行了更改？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！