Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ankur Duplicate value in Identity column RE: Duplicate value in Identity column
Rose Bud
Hall of Fame
Points: 3147
More actions
August 16, 2010 at 8:39 am
#1207397
Interesting. Very surprised to learn you can enter duplicate values when inserting explicit values.
Further surprised to learn that you can get duplicate values by resetting the identity seed, according to this person:
http://beyondrelational.com/blogs/jacob/archive/2009/02/03/sql-server-identity-why-do-i-have-duplicate-identity-values.aspx