Monday, September 13, 2010

Re-initialize an identity field seed

In order to re-intialize an identity field in a table, the following command is needed (SQL 2005):

dbcc checkident ('<<table>>',reseed,<<new seed>>)

No comments:

Post a Comment