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.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass