Groups | Blog | Home
all groups > sql server replication > november 2005 >

sql server replication : Row Guid


CLM
11/21/2005 3:40:02 PM
I thought I read that 2000 transactional replication used a ROW Guid on the
subscriber. But I just looked at the test instance I set up and I see no
such thing. If Sql Server does not use a RowGuid, how does it keep track of
Tejas Parikh
11/21/2005 3:50:03 PM
Trans replication doesn't use rowguid. Only Merge uses it. Trans, (immediate
and queued) use ms_repl_tran_version) to keeep track. If it's only a one way
Hilary Cotter
11/21/2005 7:35:54 PM
It uses the rowguid key if you are using immediate updating, immediate
updating with queued failover, or queued.

--
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

[quoted text, click to view]

AddThis Social Bookmark Button