Remember Identity

If the table has an Identity column whose value will be needed by a single-row inserting program, select this option.

Then, when a single row is inserted into the table, the system stores SCOPE_IDENTITY() in a process variable named SESSION_IDENTITY(table_name), if it is already defined.