sql server replication: HI there,

just wanted to know if there is a way to replicate my database without
adding the MSrepl_tran_version column to my tables? This column is
creating a stuff up in my asp code. I am not sure what is NOT FOR
REPLICATION option and where can I enable/disable it?

use bi-directional transactional replication for this.

Do a search on Implementing Nonpartitioned, Bidirectional, Transactional
Replication for an example of how to implement this.

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

Kanjar,
if you are using snapshot or transactional publications that allow updatable
subscriptions then this column is required.
NOT FOR REPLICATION is an option on identities, FKs and triggers. If you
look in BOL for 'CREATE TRIGGER' you'll see details about its use. Basically
it is telling SQL Server not to apply the constraint, identity, trigger code
etc to data originating through the replication process.
HTH,
Paul Ibison