Invalid column name 'msrepl_tran_version'

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Invalid column name 'msrepl_tran_version'

Author

Topic

magictech
Starting Member

44 Posts

Posted - 2004-11-23 : 13:10:27

I'm getting an error message that says
'Invalid column name 'msrepl_tran_version'.
(Source: bbccgg (Data source); Error number: 207)'

on a Transaction Replication that I setup to copy data between two database. Does
anyone have any idea why I'm getting this error message when a user is trying to insert data in the publisher database? Please any information would be greatly appreciated.

Thanks is advance

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-11-24 : 01:32:59

check if the subscription table (article) has this column.

--------------------
keeping it simple...

magictech
Starting Member

44 Posts

Posted - 2004-11-24 : 08:45:49

Thanks for your responds. I checked and the subscription tables doesn't have the msrepl_tran_version column.

pskobel
Starting Member

1 Post

Posted - 2008-05-12 : 11:12:11

Here is a link to a website that shows you the script to generate a script for all the tables in your database to delete the constraint and the msrepl_tran_version column.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-12 : 11:20:37

Brilliant! so you found answer after 4 years.

AMALKOUN
Starting Member

1 Post

Posted - 2008-07-03 : 05:29:13

what's the link please. I'm very interested in this issue.

Thanks.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-03 : 08:36:04

Do you have any problem with it?