Reset Identity Column Value In Sql Server

added by amit.jain
3/27/2012 8:36:03 AM

-1 Kicks, 65 Views

f we delete All data from Sql Server table having Identity Column with Identity Seed as 1 and insert new data Identity column value doesn't get reset and it starts from last number.