December 25, 2003 at 3:06 am
Hi!
Trying to run:
...
EXEC @RC = sp_article_validation
@publication, @article, @rowcount_only, @full_or_fast
PRINT @RC
Get this:
Generated expected rowcount value of 17 and expected checksum value of -468666793 for Table1.
0
Does it mean that article validation was successfull for all subscribers?
Similar to the above:
...
EXEC @RC = sp_publication_validation
@publication, @rowcount_only, @full_or_fast
PRINT @RC
Get:
Generated expected rowcount value of 165 and expected checksum value of 1483181184 for Table1.
Generated expected rowcount value of 12 and expected checksum value of 3824802031 for Table2.
Generated expected rowcount value of 46 and expected checksum value of 2074754471 for Table3.
0
Does this mean, that publication validation was successfull for all subscribers?
Thanks.
December 26, 2003 at 7:44 am
The value 0 in the @rc variable doesn't mean that the validation was succesfull. Only means that the sp executed suscesfully.
If you executed that sp in your publisher then you olny calculate the results in the publisher. Then you must start the distribution agent, so that SQL automatically runs the same sp in the subscribers to get the results there.
And then in your Replication Monitor, in the history of the transactions you will see the results of the validation.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply