Viewing Current Trasaction Isolation Level

[Kenjan]

Does anyone know how to see what the current Transaction Isolation Level is set to?

 

[JayKusch]

The level of isolation is actually customizable for each transaction not for database. The default of course is Read Committed

Thanks

J. Kusch

 

[JayKusch]

Sorry ... Let it loose before I was done ... Here is the syntax to find out what the current isolation level is :

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
GO
DBCC USEROPTIONS
GO



Thanks

J. Kusch

 

[Kenjan]

I saw this somewhere, but was confused. Doesn't the command 'SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED' set the isolation level? I was afraid that DBCC USEROPTIONS would just show me what I set in the command before.

 

[JayKusch]

Yes it does set the isolation level. It is being used as an example. Once again, the level of isolation is actually customizable for each transaction not for database. So when you set the ISO level for the transaction you are working with, you can view what the ISO level was for that transaction by executing the DBCC command. Sorry for not being clearer on the code.

Thanks

J. Kusch

 

[Kenjan]

OK! Thanks a lot!