[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4051
  • Last Modified:

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'

0
Mateen
Asked:
Mateen
  • 5
  • 3
1 Solution
 
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
 
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now