>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.
If it's not broken, fix it until it is.
My Blog