Jun 3, 2011

Reset AutoIncrement in SqlServer after Delete

I got solution for reset auto identity key to 1.

Just run below query and get result

DBCC CHECKIDENT (TableName, RESEED,1)
hope it will help you

1 comment: