>>See this topic in BOL
>>"Adjusting Transaction Isolation Levels". So it looks like you can set it in SQL Server only through T-SQL (no option in SSMS) or you can set it from ADO.NET It doesn't say if you can get it from there, but perhaps you can try.
>
>Setting it shouldn't be a problem. But, I need to know the current setting in order to avoid testing again assuming that the setting we would change would have been in reality the previous setting.
I understand, but I haven't found it yet. It's also hard to google on this question, too many unrelevant results returned.
If it's not broken, fix it until it is.
My Blog