>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.