I ran the following query:
SELECT session_id,CASE transaction_isolation_level WHEN 0 THEN 'Unspecified' WHEN 1 THEN 'ReadUncommitted' WHEN 2 THEN 'ReadCommitted' WHEN 3 THEN 'Repeatable' WHEN 4 THEN 'Serializable' WHEN 5 THEN 'Snapshot' END AS TRANSACTION_ISOLATION_LEVEL FROM sys.dm_exec_sessions Where transaction_isolation_level = 4
where 157 was one of the prior session_ids, to see the statement of one of the results from query no. 1.
It showed the following:
@ID uniqueidentifier) SELECT * FROM PS WITH (NOLOCK) WHERE ID = @ID
How can the statement using
WITH (NOLOCK) run with isolation level Serializable? Is there anything "overriding" the