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