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

Popular posts from this blog

Cursor error with postgresql, pgpool and php -

c# - how to write client side events functions for the combobox items -

ssh client with paramiko (python) -