Checksum returns different number for same string on different servers?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Eric Mamet (eric_mamet_test_at_yahoo.co.uk)
Date: 04/20/04 

Date: 20 Apr 2004 08:46:34 -0700

Hi,

I used CHECKSUM on the first row in syscomments to detect differences
in stored procs and user defined functions between databases/servers

In the past, it worked very well but I am now having problem with
checksum returning different values between 2 servers.

Both have the same version and each database use the same locale.
One of the "servers" is my machine and use a MSDE engine. Could MSDE
implementation of CHECKSUM be slightly different?

Thanks

Eric Mamet

Relevant Pages

  • Re: Checksum returns different number for same string on different servers?
    ... I believe CHECKSUM is affected by the collation setting. ... machines have the same version and service pack. ... >in stored procs and user defined functions between databases/servers ...
    (microsoft.public.sqlserver.programming)
  • Re: major DNS hiccup
    ... So it probably isn't in the answers your bind gives as long as ... have a checksum, I wondered if packets were being truncated somewhere. ... Truncated packets should show up as such: IP keeps a length and the NIC ... point resolv.conf at ntl's servers instead of 127.0.0.1, ...
    (comp.unix.bsd.freebsd.misc)
  • Re: how tripwire is deployed?
    ... would TRIPWIRE be deployed on the gateway to the server ... If you're familiar with what TripWire is, you'll see that it must be ... deployed on the servers. ... checksum at a later date, and comparing it to the original. ...
    (comp.security.misc)
  • Shorter checksum than MD5
    ... i'm looking for a simple way to checksum my data. ... byte hex md5sum would increase the size of my ... slow internet connection. ... unneeded traffic between the 2 servers. ...
    (comp.lang.python)