>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.
--sb--