SQL Learner (8/28/2009)
Thanks a lot GSquared....From what I got is
I will have to add checksum column for each column that may change ...
Source as well as Target...
--edit
You need only a single checksum per row, based on all the columns whose values you are tracking for changes, eg
select checksum('A','B','Z')
34391
That's how you get the speed benefit - you need only compare two columns (PK and checksum) when looking for changes, rather than all columns.
Note also Gus' comments about Checksum and Binary_Checksum
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.