sql server replication: Theo,
this column is used for updatable subscribers, not bidirectional
transactional replication.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Hi,



I'm pretty new to SQL Server 2000. I'm working on a solution for
replicational transaction.

I have setup a test environment, which works quite well, except for one
thing:

I've noticed that during the setup of the test environment every published
table is extended by a column named 'msrepl_tran_version '.

I understood from other publications that this additional column is
necessary for bi-directional replication. This is not what we need. We need
uni-directional replication (just replicate all processed transactions to
the subscriber).

- Is it possible to setup transactional replication without the need of the
additional column (msrepl_tran_version) added to the published tables?

- If yes, how do I have to configure this using the SQL Server Enterprise
Manager?

- Is it true that the 'msrepl_tran_version column is only needed for
bi-directional replication?



Thanks in advance



Theo Linnenbank