Audit Trail Processing?

Audit Trail Processing?

Does anyone know of a good article or book which describes how to implement Audit Trail processing for an application which runs on a SQL Server Database?

Please let me know the link and etc.

R

Here are few links:

http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec04.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx

http://www.microsoft.com/sql/partners/technologysolutions/security.asp

Additionally, auditing also depends on your requirements and how you want to implement the process. You can also look at the 3rd party solutions on top of SQL Server.