SQL数据库所有更改的事件日志。 [英] An event log of all changes to an SQL Database.

问题描述

我做了一些谷歌搜索，但没有找到明确的细节（说实话，我没有严格检查谷歌）尽管如此，我基本上想跟踪谁登录，谁改变了什么（删除或添加或更新）in我的c＃程序中的sql server 2005数据库。我在哪里/如何开始？

I did some googling, but didn't find clear details (honestly I didn't rigorously check google) nonetheless, I basically wanna track who logged in, who changed what (delete or add or update) in an sql server 2005 database from my c# program. Where / How do I begin?

推荐答案

您可以使用一些内置的安全审核，并且有第三方审核工具。您可能想要搜索sql审核工具。这比尝试自己编写要容易得多。

There are some built in security audits you can use and there are third party auditing tools. You may want to search for sql auditing tools. That will be much easier than trying to write it yourself.

检查以下链接



跟踪数据更改（SQL Server） [ ^ ]

这篇关于SQL数据库所有更改的事件日志。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！