[dba-SQLServer]Ideas comments HELP

Djabarov, Robert Robert.Djabarov at usaa.com
Thu Oct 30 13:55:08 CST 2003

See checksum in BOL.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin
Sent: Thursday, October 30, 2003 3:18 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer]Ideas comments HELP 

Heres the idea

We have a hand held scanner which contains a table
We link Said scanner to SQL Server
If the table data on scanner is different in any way to the data in the
same table on SQL Server we replace SQL Server table with the scanner
table or just the different rows.


1. Whats the best way to do this?
2. Can this be done without pulling the table of the scanner? 3. Is
there anyway we could create checksums for a table and compare them?

Any one any clever ideas. Speed is a real issue here.


dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list