Monday, March 12, 2012

Identity Key

I know identity key in a table can cause problems when the table is replicated. Should we avoid using identity key altogether, if we don't know in advance whether replication will come into the picture?

Thanks for any advice.I'm not absolutely positive, but I would think that if the source and destination tables have the same identity seed (starting value) and identity increment, then there should be no data corruption.|||A problem may arise if the source table's identity key is in broken sequence.

Thanks.

No comments:

Post a Comment