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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

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"
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MateenAuthor Commented:
Hi buintje

How can I remove the table(article) colour from publishing article.
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.


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

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

Learnt, how to delete an article etc.

Thanks for your time and help.


Best regards

Mateen
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.