SQL Audit Program

SQL Server 2008 offers a tool called SQL Server Audit. It basically uses extended events to track what happens on the server. You have a degree of control over it. Here is a good place to start reading about it.

Checkout this tool from Apex. Also take a look at this page about SQL Server auditing tool reviews.

Good Luck!

Permissions audit?

Access audit?

I have created an access/ logon audit based on logon triggers. Example http://www.sqlservercentral.com/articles/SQLServerCentral/sqlserver2005logontriggers/2366/

To audit permissions, I recommend you check out this article. http://jasonbrimhall.info/?p=391

If you are looking to audit data rather than server events then you could try SQL Table Audit. Otherwise I would suggest SQL Sever Audit.

Hi,

To perform a quick and easy auditing of the SQL Server, you can try in a utility tool named LepideAuditor for SQL Server which I have tested and is able to do such audit tasks easily. This tool audits both server and database objects and can report on what, when, who and where for all the changes done in it. Whether you are making the changes in the tables or the stored procedures in the database, it will generate report for all these changes done.