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
No comments:
Post a Comment