>>
I understand there are potential problems using Identity fields in SQL to generate a PK.

1. Trying to return value with @@identity may give value for insert on another table
<<

Not if you use a stored procedure to add records. After the insert, assign the value of @@Identity to an output variable. Or, just return @@Identity.


< JVP >