Wednesday, 12 September 2012

Reset the autoincremet key

For Resetting the autoincremet key use following syntax.
 
DBCC CHECKIDENT('databasename.dbo.tablename', RESEED, number)