>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 Boris said, SQL Server should be able to pick up the latest manually set by insert identity value and continue from it.