GilaMonster (10/16/2012)
Shouldn't block other inserts, unless for some reason the insert takes a table lock.
Upon rollback the identity values will have changed, rollback doesn't undo identity increments. Gaps are possible and normal.
Aha moment!
now that sounds allot better, many thanks for answering.
C# Gnu
____________________________________________________
Excel Database Tasks : efficient business data processing
Version 3.3 released February 2015