Replication — Invalid column name 'msrepl_tran_ve | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replication — Invalid column name ‘msrepl_tran_ve

I’m getting a error message that says
"Invalid column name ‘msrepl_tran_version’.
(Source: bbeddd (Data source); Error number: 207)"
when a user try to insert data in one of the tables that part of Transaction replication between two database. When I look at the table, In found out that transaction replication have added an addition column to the replicated tables call ‘msrepl_tran_version’. Now replication is failing with this error massage. Does anyone know how to fix this problem? Please any information would be greatly appreciated. Thanks in advance Regards Magic
As you’re using Transactional publications that allow updatable subscriptions then this column is required. NOT FOR REPLICATION is an option on identities, FKs and triggers. If you look in BOL for ‘CREATE TRIGGER’ you’ll see details about its use. Basically it is telling SQL Server not to apply the constraint, identity, trigger code etc to data originating through the replication process. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>