What is "msrepl_tran_version"?

Sql Server 2000.

The replication ( transactional, push method) was running fine.

I added an article ( table colour).

The replication has been stopped not only for colour table but for other tables as well.

The error is

"invalid column_name 'msrepl_tran_version'

MateenAsked:
Who is Participating?
 
bruintjeCommented:
not sure if you can drop that column
source: http://msdn2.microsoft.com/en-US/library/ms151740(SQL.90).aspx
---------
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.
---------

so only when you stop publishing the table is the column dropped, if that errors on not having the column on the published side i think you need to add it also
0
 
bruintjeCommented:
Hello Mateen,

if i understand it correctly a published table is extended by a column named 'msrepl_tran_version' this column is used for updatable subscribers

so what happens i guess is that the table on the publisher side has no column like that and the replication fails

hope this helps a bit
bruintje
0
 
MateenAuthor Commented:
Hi bruintje

Thanks for your answer.

You r right.

This is a case of foreign key ( enforce relationship for replication). A quite many are ticked in tables.
Now I want to know what are those foreign keys.

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21826058.html

I dont want 'msrepl_tran_version'  in subscriber side, So how to delete from Publisher side.

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
MateenAuthor Commented:
or how to delete the column 'msrepl_tran_version' from table colour.

Currently it says,
" column cannot be droped as it is being used in replication"
0
 
MateenAuthor Commented:
Hi buintje

How can I remove the table(article) colour from publishing article.
0
 
MateenAuthor Commented:
Hi bruintje

I have dropped the column.

The related tab name is [filter columns]. Untick the column 'msrepl_tran_version' . After that, the column could be deleted from the physical table.


0
 
bruintjeCommented:
thanks for posting the exact solution, sorry missed that one here

thanks for the grade
0
 
MateenAuthor Commented:
I did learn a lot,

Learnt, how to delete an article etc.

Thanks for your time and help.


Best regards

Mateen
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.