Hello,
Can someone help me with the syntax of sp_publication_validation. I have a server named "EXT" and it's a subscriber to another server named "PUB". I would like to know what syntax and where to run the TSQL statement to check a table (or group of tables I really don't understand if this command does all tables or just one at a time). The database name is "testDB" on both environments.
Thanks,
Phil
Hello,
I'm wanting to compare replicated data accross all our subscribers. I would like to do this in an automated fashion, but want to manually update/fix the data. I was reading about sp_publication_validation and I've executed it on our publisher. I was thinking about capturing the results from each article and storing the row in a column someplace. The output is like this:
Generated expected rowcount value of 2048198 and expected checksum value of 71435190759406 for peo_address.
Because we have multiple subscribers this doesn't do me any good in telling me which subscriber is off compaired to the publisher. The sp_article_validation also is to be run on the pub, but from what I can tell it does the same thing that sp_publication_validation does only for one article at a time. Here is my question, is there a way to get this specific string of row count and checksum information and capture the results for each subscriber and each article? I want to capture this information and then store it so I can tell exactly which subscriber and which article are not matching.
Also, if somebody else has done this before or something like it and has any advice, please share.
Thanks,
Phil
I'm trying to put together an automated system that uses sp_publication_validation & the tablediff utility to automatically sync up our subscribers to the publisher. What I'm noticing is that the sp_publication_validation sys proc gets run on the publisher. It does a rowcount and binary_checksum of each article in a specified publication. When I do a binary_checksum myself I've verified these results. For some reason a column could be a smalldatetime on the publisher and all the subscribers, however, the binary checksum will be different IF RUN from the publisher for that column/row/table. If I run the binary_checksum from the subscriber (instead of accross ODBC using a linked server command) I'm seeing matching checksums.
The result of this is I'm seeing a bunch of records that are actually identical coming through the tablediff command as different. I have a few questions. Has anyone ever run accross this issue before? I believe it has something to do w/ ODBC. I'm willing to work/share a pretty nice SSIS package that I am developing if somebody could assist me in figuring a way around this issue.
Thanks,
Phil