>>Hi,
>>
>>Is there a way in SQL 7/2K to "set" the @@identity value of an EXISTING table/identity field with lots of data already in it to a specific value that the next inserted record will use? I want to "stop" the current identity counter and have it restart with certain numbers.
>>
>
>You can use DBCC CHECKIDENT with RESEED parameter. See BOL for details.
thanks - that does the trick!
Ken B. Matson
GCom2 Solutions