Reset ID

[WJProctor]

Ok i know it doesnt matter what the auto increment number is at, but is there a way i can reset so while testing my system, if i delete all the records i can keep it neet by starting at 0 again. Hope someone can help

Regards

James Proctor

http://www.ebmis.co.uk

 

[JohnDTampaBay]

Check out DBCC CHECKIDENT in BOL for info on reseeding an identity column.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.