>>I have a VFP program to copy over VFP tables into exisitng SQL Server Table
>>The SQL SErver table has an Identity with an Identity Seed
>>How do I : Set Identity_Insert off,and after I have imported the data, set Identity_Insert on and also set the Identity Seed to a new number
>>
>>I think I can set the Identity Insert by putting following into a string:
>>SET IDENTITY_INSERT MYTABLE OFF
>>IMport the VFP data
>>SET IDENTITY_INSERT MYTABLE ON
>>
>>Not so sure how to set the seed though ?
>>
>>Tia
>>Gerard


As I said, there is no need to do anything with the seed.
Just do:

SET IDENTITY_INSERT YoruTable OFF
--- Do the Insert and make sure you didn't insert duplicated values
SET IDENTITY_INSERT YoruTable ON

That is all.
SQL Server will handle the re-seed of the column.