[dba-SQLServer] Building tables

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 




More information about the dba-SQLServer mailing list