Data Capturing techniques in Sql server 2005 Express Edition

I am using C# and Sql Server 2005 Express Edition.

I am doing logging in my application. Right now I have following two way to do that

1. Enterprise library
2. Manually inserting the logs in tables.

开发者_如何转开发Is there any way to do Data Capturing more efficiently ?

I know a lot of people dislike triggers, but in my experience they are a very effective and easy way to implement audit logging in SQL. Here is a good walk through on how to do it.

Enterprise Library is good. As it also help to gain variety of database connectivity significance

Have you used SQL Log Rescue?

SQL Log Rescue is an award-winning log analysis tool, allowing you to explore your logs to view information on database transactions. Additionally, SQL Log Rescue should be kept on hand in case of a potential disaster – if you have accidentally deleted, inserted or modified your database, SQL Log Rescue will help you get the data back.

Also read this: Tracking Changes in Your Enterprise Database

Just one note if you go to SQL Server 2008 CDC way, it requires (IIRC, can't find good edition comparison doc now) the enterprise edition.