ABout identity column in replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Iter - 29 Jan 2007 19:42 GMT

Hi Guys,
I read the microsoft article about how to handle the identity column in
replication. There is sentence: " If you are using transactional replication
with the immediate-updating Subscribers option, do not use the IDENTITY NOT
FOR REPLICATION design." That means I can not use the IDENTITY NOT FOR
REPLICATION option when I want to use transactional replication with the
immediate-updating Subscribers options, is that correct? That also means I
cannot created identity column in subscriber, right? If I do need to create
identity column in the subscriber, how can I work around? Thanks

Reply to this Message

Hilary Cotter - 30 Jan 2007 23:42 GMT

This isn't correct. If you have immediate updating you don't need NFR as the
transaction is applied on the publisher before the subscriber.

You can use NFR and identity columns on the subscriber, however, but it is
not necessary.

Signature

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

> Hi Guys,
> I read the microsoft article about how to handle the identity column in
[quoted text clipped - 8 lines]
> create
> identity column in the subscriber, how can I work around? Thanks

Reply to this Message