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
Reset AutoIncrement in SqlServer after Delete
4:34 PM
ahmedabad, Auto Increment key, india, reset auto identity key, software developer, software development, sql server
1 comment
DBCC CHECKIDENT (TableName, RESEED,1)
really great...
ReplyDelete:)