Why does this lock the entire table when only one of the rows is locked in a transaction? I thought the first two inserts were implicit transactions - so they would be committed when they ran? Or is is just locking the entire table because all 3 rows are on the same page?

I have always wondered exactly how this works at this level. I seem to have more locking issues on new systems with few rows in the tables.

CREATE TABLE Test_Tran( col1 int)

insert into Test_Tran values(1)

insert into Test_Tran values(2)

Begin Tran

insert into Test_Tran values(3)

--------------

--2nd window

--------------

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

select * from test_tran