>>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 asked this question on another forum and the answer is very simple.

Try this query
DBCC USEROPTIONS
GO

The last record shows the transaction isolation level.

http://forums.asp.net/p/1317697/2612571.aspx#2612571