sp_article_validation failing......

  • if i run the procedure sp_article_validation for some of my articles in a certain publication i get a different number than if i ran a count(*) on that table.

    If i run a count(*) on the publishing table (with the filters) i get the same value as the subscribing table but not when i run teh validation procedure above. Its not as if its only a couple of rows out but its about 200k rows!!!

    any iedas why it may be doing this? All other publications are fine.....

    _________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

  • Are the publisher and subscriber the same version?

    There could be issues when you use 2000 vs 7 vs 2005...


    * Noel

  • i think i may have an answer for why it is happening. Every evening we perform a delete of certain tables from that publication (on the replicated server) to keep a rolling 3mths of data (the filter on the articles are rolling 3mths too). Could this be messing up the checksum in anyway?

    If this is the issue, is there any other way of keeping a rolling amount of data apart from from creating a daily snapshot?

    _________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

  • anyone??

    There must be a better solution than creating a snapshot every day/week......?

    _________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

  • row counts are not necessarily the same as the actual rows.

    You should use tablediff or any other diff tool to determine if the rows are exactly the same. If they are not you can sync the tables using the script generated by the sync-tool of your choosing.

    There are occasions in which the log-reader could miss some transactions


    * Noel

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

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