I am currently building a script to populate a database with an initial set of data. As the database will potentially be brand new (but may not be) when the scripts are run I want to find a way to set the value the next insert will put in an identity column after the initial set of records are in. If the database is brand new I don't want new records overwriting or causing problems with the initial set. If the database was previously populated the values are deleted and the initial set is re-inserted, but in this case I don't want the new records to be placed with IDs too far removed from the IDs used in the initial set.
I am fairly certain it can be done, but after trawling through the docs I can't seem to find what I am looking for - The initial value can be set when the table is created, but I'm doing that after the table is created.
"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)