Here's a repro:

CREATE TABLE Production (effdate SMALLDATETIME, termdate SMALLDATETIME)
CREATE TABLE Replicated (effdate DATETIME, termdate DATETIME)

INSERT INTO Production VALUES ('20021001', '20781231')
INSERT INTO Replicated SELECT effdate, termdate FROM Production

SELECT CHECKSUM(effdate),CHECKSUM(termdate) FROM Production
SELECT CHECKSUM(effdate),CHECKSUM(termdate) FROM Replicated

Result:

----------- -----------
-1835532288 -10354688

(1 row(s) affected)


----------- -----------
37528 65378

(1 row(s) affected)


Based on your description I'm certain the columns you're running the
CHECKSUM against on the Replicated server are DATETIME rather than
SMALLDATETIME. Is there a possibility that you're looking at a view rather
than the base table?

If you still have a problem, please could you post your CREATE TABLE
statement from the Replicated copy and your code that produces the checksums
(as above).

--
David Portas
------------
Please reply only to the newsgroup
--

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote:>

Thanks for everyone's help. I decided to byte the bullet and create a
new snaphsot and resync the subscription. The CHECKSUM values are now
working. :-)

Kind Regrards,
Stephen Rosales