SQL Server 2008 - Best way to log Inserts, Updates and Deletes.

Hi..
I have a customer table. I need to log , create an audit log of all the changes to the data by a user.

What's the best way of doing this in SQL2K8....  use a trigger and insert into a audit table?
LVL 1
JElsterAsked:
Who is Participating?
 
RehanYousafConnect With a Mentor Commented:
One option is to use Change Data Capture
http://msdn.microsoft.com/en-us/library/bb522489(v=sql.100).aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.