>>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
>
>Don't.
>SQL Server handles the seed by itself.

Agreed. Don't know why you would need to reseed.

It is possible though..
http://www.techrepublic.com/blog/datacenter/how-do-i-reseed-a-sql-server-identity-column/406