I have sql2008 r2 with READ_COMMITTED_SNAPSHOT ON.

So, default database isolation level is read commited with row versioning.

If i try this:

--first connection

BEGIN TRAN

SELECT 1 AS test INTO dbo.test

--second connection

SELECT * FROM...