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.

Thanks!