Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

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?
0
JElster
Asked:
JElster
1 Solution
 
RehanYousafCommented:
One option is to use Change Data Capture
http://msdn.microsoft.com/en-us/library/bb522489(v=sql.100).aspx
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now