thanks all of u guys. Trying it out.

Thanks. Can this be done using intersect/except...? Guess this can be a little faster using sets...?

Thanks. experts. But I just wonder if the six-core would fit SQL server 2008...? Not sure if multiple cores from quad CPUs rather than 6 core CPUs would make...

Thanks for ur reply. I might have mistaken sth. I think got it now.

Besides thanks for u guys hint last time on - sync 2 DBs without primary...