resetting identity value - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

resetting identity value

Author

Topic

Gareth_S
Starting Member

3 Posts

Posted - 2001-01-12 : 11:15:44

Hi all,
does anyone have a suggestions on how to go about resetting an INT primary key field back so the next insert will generate 1 instead of 9992 (or whatever) - I've removed all of the data that was there before you see...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources