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 |
|
HenryFulmer
Posting Yak Master
110 Posts |
 Posted - 2011-07-22 : 08:42:36
|
I have a table in which I keep track of changing parameters for SKU numbers.SKU_no status visible location------ ------ ------- --------D-102 1 0 ED-103 2 1 G Every night I am looking at the data source and import all SKU information into a work table. Now I would like to insert all those records into my tracking table for which one or mare of the paramteres have changed.Any advice would be appreciated. |
|
|
eralper
Yak Posting Veteran
66 Posts |
Posted - 2011-07-22 : 08:49:07
|
| Hello Henry,I developed a tool which works with a trigger on the table and logs changes table column, and values[url]http://www.kodyaz.com/articles/log-data-changes-using-change-data-capture-for-sql-server-2005.aspx[/url] Maybe this structure can help you easily track changes on any table-------------Eralperhttp://www.kodyaz.com |
 |
|
|
|
|
|
tracking changes