After you delete records from a table, if you want to set the Identity Seed back to zero:
DBCC CHECKIDENT('msci3025_f14.dbo.msci3025_surveyData', RESEED, 0)
http://www.mikecolbertonline.com
After you delete records from a table, if you want to set the Identity Seed back to zero:
DBCC CHECKIDENT('msci3025_f14.dbo.msci3025_surveyData', RESEED, 0)