Jim Lawrence
accessd at shaw.ca
Wed Aug 10 11:41:33 CDT 2005
Hi All: I have been porting a legacy database into a new MS SQL set of tables. In the process the data is added and removed several times as improvements are made on the table structures and the DTS is tested. Each time the import process is re-ran the auto ID identity values, of course, continue to increment. The field can be re-set manually by changing the ID field type, clearing the table content and changing the field type back; all very labour intensive. Is there a simple way, in code, to initialize the auto ID identity values so it re-start at the initial seed value? MTIA Jim