Post reply

Subscription validation

  • March 18, 2004 at 10:07 am

    #84723

    Hi!

    I have a table with a field of image type.  Trying to validate it:

    validate subscriptions -> validation options, then combine all possible options variations.  Get a netsend message that subscribers pass data validation.  At the same time I have one (or more) records with empty image field on all subscribers, that is filled on the publisher.  So this procedure does not give pricise result.

    How can I make sure if my data is valid on subscribers?

    Thanks.

     

  • March 18, 2004 at 6:28 pm

    #499436

    What Replication Model are you using?

    Kindest Regards,

  • March 18, 2004 at 11:30 pm

    #499444

    This is transactional replication...  And this is all about MS SQL 2000 Ent Ed + sp3...

  • March 21, 2004 at 8:08 pm

    #499690

    So how are you replicating Image Columns? The only Replication Model that allows you to Replicate the Image and Text/NText DataTypes is Merge Replication!

    Kindest Regards,

  • March 22, 2004 at 6:07 am

    #499737

    You can replicate image columns in transactional replication, but the validation that SQL uses it is a count from the table (or the rows columns in sysindexes) and a checksum. But validataion will skip the image/text columns.

     

    You can create your own validation script using

    CHECKSUM_AGG with BINARY_CHECKSUM. Check in BOL for parameters.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply