Replication

Mssql 2005 - Mssql2000
I try to create a "Transactional publication with updatable subscriptions:"
But I can see that all tables cet an added colunm "msrepl_tran_version"
Is it possible to replicate 2-way that wil not add this column
(msrepl_tran_version)?
What will happen if I set up "Transactional publication" in both Database.
ie. both is a Publisher and Subscriber at a same time?
The data that will be updated and inserted will newer confilct in our
environment. (The Software we use manage this.)
Roger Nygrd
Ask IT
Roger,
these links should help you set up bi-directional transactional replication:
http://support.microsoft.com/default...b;en-us;820675
http://msdn.microsoft.com/library/de...lsamp_3ve6.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||It works well. You don't need this msrepl_tran_version column. Please see
this script for an example of it.
http://www.indexserverfaq.com/bidireproscript.sql or
http://www.indexserverfaq.com/Mike1.sql
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roger Nygrd" <roger@.askit.no> wrote in message
news:11surfla2d9svab@.corp.supernews.com...
> Mssql 2005 - Mssql2000
> I try to create a "Transactional publication with updatable
> subscriptions:"
> But I can see that all tables cet an added colunm "msrepl_tran_version"
> Is it possible to replicate 2-way that wil not add this column
> (msrepl_tran_version)?
> What will happen if I set up "Transactional publication" in both Database.
> ie. both is a Publisher and Subscriber at a same time?
> The data that will be updated and inserted will newer confilct in our
> environment. (The Software we use manage this.)
> Roger Nygrd
> Ask IT
>
>