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 |
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
 Posted - 2009-01-15 : 13:23:59
|
| I truncate and populate my table nightly. I would like to compare the new table to a day old copy to get a count of the rows that were added or changed. Can checksum help? if so, how do I setup checksum column in a table? Is there any other way to do this. This is SQL 2000 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 13:37:01
|
| Can't you have trigger do this? |
 |
|
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
Posted - 2009-01-15 : 13:40:16
|
| This is not a transactional DB. I truncate it each night before making a copy and then populate it with data from a legacy system. |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-01-15 : 14:40:29
|
| Have a look at this,http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx |
|
|
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
Posted - 2009-01-15 : 17:17:57
|
| Hi Sakets.. This seems to work like a charm. I still need to verify closely, but from the face of it, it works great. Thanks |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-01-15 : 17:46:08
|
| np. |
|
|
|
|
|
|
Checksum for Table Changes