>Anyone know if it’s possible to get the value for an SQL server identify field before a transaction is completed.
>
>Basically I want to add a record to a table, get its PK value which is assigned in SQL server. Then add to some other tables and if everything goes well, commit the transaction to all tables.
>
>Thanks,

You can use SCOPE_IDENTITY( ) or @@Identity to get last identity value. See BOL for details and limitations of each.