sql - Validation stored procedure for Replication -
does know of correct stored procedure validates actual code in transactional replication? have view select * table1. changed view select * table2 in publisher , there error in replication monitor (as there should be) when run sp "sp_publication_validation" validates.
sp_publication_validation row count and/or checksum check @ publisher , subscriber , compares 2 results. if compare same, article considered "good" , if not, it's considered "bad". now, how view fit replication setup? have view published article? if so, value schema_option in sysarticles (at publisher)? also, error getting in replication monitor?
Comments
Post a Comment