[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Setting up transactional replication in sql server 2008

Posted on 2009-12-17
Medium Priority
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
ID: 26078156
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

ID: 26078162

Accepted Solution

SBV_DEV2 earned 0 total points
ID: 26078486
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

872 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