Validation stored procedure for Replication
Does anyone know of the correct stored procedure that validates the actual code in transactional replication? I have a view that basically is a select * from table1. I changed that view to select * from table2 in the publisher and there is an error in the replication monitor (as there should be) but when I run the sp "sp开发者_JS百科_publication_validation" it validates.
sp_publication_validation does a row count and/or checksum check at the publisher and subscriber and compares the two results. If they compare as the same, the article is considered "good" and if not, it's considered "bad". Now, how does your view fit into your replication setup? Do you have the view published as an article? If so, what is the value for schema_option for it in sysarticles (at the publisher)? Also, what error are you getting in the replication monitor?
精彩评论