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 SYSOBJECTS
OR
SELECT * FROM SYSOBJECTS WITH (NOLOCK) WHERE NAME LIKE '%test%'
This wont work.
So, the sys.objects is not available even if I have snapshot isolation with row versioning.
Is there any solution? I would like to read from sys.objects and test table should not be visible there until commit of first connection.
lp,S