Monday, March 12, 2012

Row Guid

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
everything? just by the primary key?
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
transactional, it doesn't use anything because it doesn't need to.
|||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
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:5C0574FB-C9CA-4990-98FD-232FB196D33E@.microsoft.com...
>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
> everything? just by the primary key?

No comments:

Post a Comment