Hi Jim ----
Is this a one-time shot of converting 2.6 data to SQL Server and, if so, why not set an Identity in SQL Server?
>Can someone tell me how they handle primary key generation without using record locks or an @@identity from SQL Server (converting code/tables from 2.6).
>
>Thanks
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05