Reset Identity Column Value in MSSQL Server

One of those simple tips....

While setting up some test data on two different machines my row data became out of synch, a quick Google and "hey presto"

The following line resets the Identity value for the Customer table to 0 so that the next record added starts at 1.

 

DBCC CHECKIDENT('Product', RESEED, 0)

Add comment