November 3, 2003 at 4:15 am
I am replicating a table from SQL Server 7.0 database to another machine with identical structure and using sp_publication_validation to verify that it is working ok. It always works until I switch on checksum validation (@rowcount_only=0) then it always fails on the checksum. I have backed up the database on live and restored on the contingency but it still fails. A query checking every column on both machines says they match. Any ideas?
November 3, 2003 at 5:45 am
Do you have text cols? Thought they got excluded from the check, would have to check!
Andy
November 4, 2003 at 2:53 am
no text, 1 image column, which as you say, should be excluded from the checksum.
November 4, 2003 at 5:23 am
Does the failure tell you where it's at?
Andy
November 10, 2003 at 8:55 am
After some experimenting, it seems to be the image column which causes the checksum to fail. Adding an image column to a test table at both sites using the same script immediately gives a checksum failure, even though there is no data in the column yet. I think I will just use rowcount to validate.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply