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 |
|
maevr
Posting Yak Master
169 Posts |
 Posted - 2008-12-19 : 08:37:02
|
| I have a couple of large tables with many columns, now I want to make some changes to the data in the columns and store the changes. I only want to store the table name, column name, date/time, old value and new value for only the columns that has been changed. output example:table1 col1 2008-12-19, 'test' 'test2' I am using SQL 2005, how do I do this?I have already read through som of the earlier posts in the forum regarding the problem. |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-19 : 09:05:12
|
| http://www.nigelrivett.net/AuditTrailTrigger.html |
 |
|
|
|
|
|
Audit changes to table