I added Validate Subscriptions to my publication using the procedure outlined in BOL. Procedure is listed below. I want to stop the validation for this publication. I do not want to validate any longer. How can I stop this process
To validate transactional data using SQL Server Enterprise Manager
- At the Distributor, expand Replication Monitor, expand Publishers, and then expand a specific Publisher.
- Right-click a transactional publication, and then click Validate subscriptions.
- Choose whether you want to validate all subscriptions or just specific subscriptions, and if you want to validate specific subscriptions, select those in the text box.
- To choose the type of validation, click Validation Options.
- Choose whether you want to compute a fast rowcount based on cached table information, compute an actual row count by querying the tables directly, or compute a fast row count and if differences are found, compute an actual row count.
- You can also choose to enable Compare checksums to validate data, a binary checksum (if the Subscriber is running SQL Server 2000), and you can choose to stop the Distribution Agent after the validation has completed.
Validate Subscriptions, turn it off
Clive Townsend
The error message was invalid object [object name]. I know why it threw the error, it was throwing the error because the object is owned by a user different than what replication is using to connect to the subscriber with.
I will create a job to run sp_publication_validation [ @publication = ] 'publication'.
Tim Daley
Hmmm, interesting. Well that may be the case. It was throwing an error and distribution would not go past it and finish. Every time the distributor restarted the validation process would throw an invalid object error. Therefore I wanted to turn it off so replication would continue. I have since deleted the subscription and am synchronizing again. I am now concerned with using the validation as BOL describes through enterprise manager. I think I will setup a job to run the sp separate from the distributor.
Jennifer Bhamoo
rob_a89
Exactly what is the error message The behavior you're experiencing may be by design, but I'd like to know more about the error details before confirming it.
Also, what setup job do you plan to do In the end it's the distribution agent that implements the validation, I'm not so sure you can get around that.