synchronize and compare two database in real time

Question

how to synchronize and compare two database in sql server 2000 without using any others software in real time.

my purpose is to check the two database in two different server if there has any different. And synchronize these two database continusly.

if one database had change, the other will also change

Answer 1

Replication is exactly what you need. Take a little time to discover the power of this feature (which comes with sql server 2000). In the express edition you can only make subscribers (the databases that will be synchronized), in the 'normal' edition you can also make publishers (databases that subscribers subscribe to :) )

Answer 2

If you use replication, it also has built-in validation that you can use.