MSrepl_tran_version - needed or not? -- sql server replication

gravity
4/20/2004 10:51:36 AM

Hi

Can someone please tell me, when i setup a publication for
transaction replication (push only), sometimes it says:

"SQL Server requires that all articles in a publication
allowing updatable subscriptions contain a
uniqueidentifier column named 'MSrepl_tran_version' used
for tracking changes to the replicated data. SQL Server
will add such a column to published tables that do not
have one"

But other times it does not ask to do this, and i have
successfully had a replication running without the

shrini
4/21/2004 2:05:32 AM

Hi

If you want the changes to be replicated from the subscriber to publisher,
using immediate updating or queed updating, it becomes a requirement that
uniqueidentifier column is needed. If you dont want the reverse update, then
you may not need that column. Hope it helps

shrini

[quoted text, click to view]

sql server replication : MSrepl_tran_version - needed or not?