Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLFOX
Starting Member
45 Posts |
 Posted - 2011-03-01 : 07:18:04
|
| Hi,I would like to audit ANY changes made on a table and log the audit details into another table called 'Audit'. Is there any easy way to do this? (I'm quite new to SQL).Thanks. |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-03-01 : 10:08:33
|
Every thing is easy when you know it  if you are using SQL 2008 check the Change Data Capture (CDC). Hope this would help you !!CheersMIK |
 |
|
|
|
|
|
Audit table