SQL Server Performance

Replication -- Invalid column name 'msrepl_tran_ve

Discussion in 'Performance Tuning for SQL Server Replication' started by magictech, Nov 23, 2004.

  1. magictech New Member

    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
  2. satya Moderator

    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.

Share This Page