Check integrity data in distributed database

Please tell me the way to check data integrity between server1 and server2 i
n distributed database
( Do we have a tool like that in SQL Server ?)
Thank a lots.Hi there Tuan,
What do you mean with data integrity? Do you mean to check if two databases
are identical?
Andrs
"Tuan Anh" <anonymous@.discussions.microsoft.com> wrote in message
news:8E4AE8AB-6773-4A8A-B4CA-B1E1417C7D6B@.microsoft.com...
> Please tell me the way to check data integrity between server1 and
server2 in distributed database
> ( Do we have a tool like that in SQL Server ?)
> Thank a lots.|||Hi Andrés,
When we do a distributed trasaction between server1 and server2, there may b
e have some prolems such as network failure or careless action of users. So
data on server1 is not correct with data on server2.
For example:
On server1: OrderID (primary key) ProductName
001 A
On server2: OrderID ( primary key) ProductName
001 B
Clearly, the data on server1 unfit one on server2. So how can we know this d
ifference if it occurs ?