>I would recommend using GUIDs - that way you don't have to mess with keeping the ones added in SQL Server in synch with the ones added in VFP, or with making sure you can override an IDENTITY field.
>
>You can create them in VFP with the code in this link.
>http://support.microsoft.com/support/kb/articles/Q269/3/87.ASP
>
>In SQL Server, just use NEWID() to get a new GUID and the UniqueIdentifier data type for the PK field.

So, use VFP code to generate a GUID, then take that value and issue an INSERT? When I am defining my table in SQL Server, do I define my PK with the ROWGUIDCOL attribute? Also, this database is not going to be replicated or distributed, so are GUIDs a good idea?