hey! you can use the transaction and rollback feature to fail the insert completely, in that case your identity no will not be increased