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 |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2006-09-11 : 03:41:28
|
| Hi all,I have several transaction tables on which I need to track the changes. That is I need to maitainthe history of changes. Only few column values are changed often.Which is the best way for tracking the changes.1.Store the whole record after the change ?Or 2.Store the ColumnName & its respective old & new value ?Or any other better. Note : UI part & SP's will take care of the tracking & no plans for triggers.Thanks in advance,HHA |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-11 : 06:47:07
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=audit+changesKristen |
 |
|
|
|
|
|
Tracking the history of changes.