Tuesday, March 20, 2012

Current Isolation Level

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