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,