Identity column resetting

Question

Post reply

Identity column resetting

Rahuul

Mr or Mrs. 500

Points: 581
More actions
June 4, 2003 at 5:56 am

#80174

Hi All,
I imported some rows from some other table by giving set Identity_insert on command, and droping my Primary Key, but after that i couldnot set my primary key as it's now containing duplicates.
Is there any way by which these duplicated identity rows can be reseeded, so that I can create the primary key again with Identity.
Thanks in advance

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Hi Rahuul,

what about dropping the field, save, create a new int field and make it primarykey and identity and save again?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Steve Jones - SSC Editor SSC Guru Points: 736059 More actions · Answer 2

don't remove the pk. delete the rows and reimport them without set identity_insert to give them new values.

if that's not possible, you can remove the identity (Requires a table rebuild) and then "fix" the data. Once that is done, you could rebuild the table with a new seed value that doesn't create duplicates.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net