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 |
|
Azhar Iqbal
Starting Member
2 Posts |
 Posted - 2009-05-29 : 02:36:56
|
| Dear All,I need to maintain history of data tables whenever insert,delete or update occur.I mean another table to used for old data.ThanskAzhar IqbalLeft elbow has cut. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-05-30 : 08:58:58
|
I don't know why this is a thread in Import/Export (DTS) and Replication (2000)?To build history tables to see every insert/update/delete can cause big data overhead you know?But to do that, you can use triggers.Maybe you can tell a bit more clear which data has to be saved in history table in which cases and which data is of no importance?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
How to Maintain history tables in database