resetting the identity column

DBCC CheckIDENT(tableName,RESEED,0)

Advertisements