Remember Identity

If the table has an Identity column whose value will be needed by a single-row inserting program, select this check box. 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.