Hi,
how can I get current isolation level?
I heard, dbcc useroptions can retrieve it, but I don't see anything
about isolation level in the result set.
Is there another way?
thanks.Originally posted by Wolffie
Hi,
how can I get current isolation level?
I heard, dbcc useroptions can retrieve it, but I don't see anything
about isolation level in the result set.
Is there another way?
thanks.
To determine the transaction isolation level currently set, use the DBCC USEROPTIONS statement, for example:
USE pubs
GO
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
GO
DBCC USEROPTIONS
GO
Showing posts with label anythingabout. Show all posts
Showing posts with label anythingabout. Show all posts
Subscribe to:
Posts (Atom)