Setting up transactional replication in sql server 2008

Posted on 2009-12-17
Last Modified: 2012-06-21
I have set up transactional replication in SQL server 2008.  I receive the error "Invalid column name msrepl_tran_version'. This new column is created when replication is set up. I have dropped constraints for this column & deleted the column after removing replication. But the Column is recreated when i set replication again. Any suggestion?
Question by:SBV_DEV2
    LVL 57

    Expert Comment

    by:Raja Jegan R
    Hope this helps

    "Why does replication add a column to replicated tables; will it be removed if the table isn't published?

    To track changes, merge replication and transactional replication with queued updating subscriptions must be able to uniquely identify every row in every published table. To accomplish this:

        * Merge replication adds the column rowguid to every table, unless the table already has a column of data type uniqueidentifier with the ROWGUIDCOL property set (in which case this column is used). If the table is dropped from the publication, the rowguid column is removed; if an existing column was used for tracking, the column is not removed.
        * If a transactional publication supports queued updating subscriptions, replication adds the column msrepl_tran_version to every table. If the table is dropped from the publication, the msrepl_tran_version column is not removed."
    LVL 10

    Expert Comment


    Accepted Solution

    Thanks for the info. I redid the replication using the option "Transactional publication" instead of "Transactional publication with updatable subscriptions." It works perfectly.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now