Problem With Identity ... (Urgent)

Hi all,

I had a table with two columns one identity field and second with foreign key constraint.
If my insert statement conflicted with COLUMN FOREIGN KEY constraint. My identity column getting auto incremented. But insert statement throws an error message stating that the statement has been terminated.

To be more clear,

identity_col1 col2
------------- ----
1 100
2 500
3 450

Suppose here I get an error:
Server: Msg 547, Level 16, State 1, Line 1

INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'fk_ordercode_col2'. The conflict occurred in database 'pubs', table 'orders', column 'col2'.
The statement has been terminated.

I inserted next value

5 550
6 700

Instead of 4 I get value 5 in identity_col1.

Any help will be highly appreciated.


Thanks,
venkat.