Transactional publication with queued updating subscriptions

I have dropped constraints for this column & deleted the column after removing replication.

But the Column is recreated when i set replication again. Hope this helps "Why does replication add a column to replicated tables; will it be removed if the table isn't published?

transactional publication with queued updating subscriptions-13

A subscription defines what publication will be replicated, where and when.I receive the error "Invalid column name msrepl_tran_version'.This new column is created when replication is set up.Immediate updating allows snapshot replication and transactional replication Subscribers to update the replicated data at the Subscriber and send those changes back to the Publisher and to other Subscribers.Queued updating allows snapshot replication and transactional replication Subscribers to modify published data without requiring an active network connection to the Publisher.

Leave a Reply