Sql server 2008 R2的审计跟踪 [英] Audit Trail for Sql server 2008 R2

问题描述

你好，

我想在快递版的sql server 2008 r2中实现审计跟踪。任何人都知道如何实现它。

提前多多谢谢。

Hello,
I want to implement audit trail in sql server 2008 r2 in express edition. any one know how to implement the same.
Thanks a lot in advance.

推荐答案

如你所知，SQL Server Audit只能可以在SQL Server 2008 R2的企业版和数据中心版上完成。



http://msdn.microsoft.com/en-us/library/dd392015(SQL。 100）.aspx



但是，上面提到的文章简要提到了SQL Server Trace（SQL Profiler是GUI）。 SQL Server跟踪可用于跟踪服务器上运行的所有批处理。这将为您提供良好程度的审核，但不是在SQL Server Audit提供的级别。有关于此的文章：



http://www.sqlmag.com/article/auditing/get-compliant-with-sql-server-2005-audit-logging.aspx

http://www.sqlservercentral.com/articles/Administration/auditingwithsqlprofiler/1461/



以及其他人。人们在SQL Server Audit之前使用了SQL Server Trace和Profiler多年，毫无疑问，许多无法承受更昂贵的SQL Server版本的人会继续这样做。



Happy New年...祝你好运... :)

问候，

Vijay

As you are aware, SQL Server Audit can only be done on Enterprise and Data center editions of SQL Server 2008 R2.

http://msdn.microsoft.com/en-us/library/dd392015(SQL.100).aspx

However, the article mentioned above briefly mentions SQL Server Trace (SQL Profiler is the GUI). SQL Server Trace can be used to trace all batches that run on your server. This will give you a good degree of auditing, although not at the level that the SQL Server Audit provides. There have been articles on this:

http://www.sqlmag.com/article/auditing/get-compliant-with-sql-server-2005-audit-logging.aspx
http://www.sqlservercentral.com/articles/Administration/auditingwithsqlprofiler/1461/

And others as well. People used SQL Server Trace and Profiler for years before SQL Server Audit and doubtless many who cannot afford the more expensive versions of SQL Server will continue to do so.

Happy New Year ... Wish u good luck...:)
Regards,
Vijay

是的，你可以实现触发器。

要创建触发器，您只需要找出要审核的句子，并在插入，更新或您要审核的任何事件后创建触发器。



查看以下示例：

http：/ /msdn.microsoft.com/en-us/library/ms189799.aspx [ ^ ]



或者，有第三方工具可以帮助您审核SQL Server，如SQLApex审计：



http://www.apexsql.com/sql_tools_audit.aspx [ ^ ]

Yes, you can implement triggers.
To create a trigger, you just need to find out which sentences you want to audit and create a trigger after an insert, update or whatever event you want to audit.

Check the examples here:
http://msdn.microsoft.com/en-us/library/ms189799.aspx[^]

Optionally, there are third party tools that can help you to audit your SQL Server like the SQLApex Audit:

http://www.apexsql.com/sql_tools_audit.aspx[^]

这篇关于Sql server 2008 R2的审计跟踪的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！