Setting up transactional replication in sql server 2008

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?
SBV_DEV2Asked:
Who is Participating?
 
SBV_DEV2Author Commented:
Thanks for the info. I redid the replication using the option "Transactional publication" instead of "Transactional publication with updatable subscriptions." It works perfectly.
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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."

http://msdn.microsoft.com/en-us/library/ms151740%28SQL.90%29.aspx
0
 
MuraliCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.