C# Gnu (10/16/2012)
Can I confirm I understand this correctly - I believe no other connection will be able to insert into the Orders Table until commit or rollback, and upon rollback the next identity value of the Orders table will not have changed.
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability