I have sql2008 r2 with READ_COMMITTED_SNAPSHOT ON.
So, default database isolation level is read commited with row versioning.
If i try this:
SELECT 1 AS test INTO dbo.test
SELECT * FROM SYSOBJECTS
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.