SQL Server Performance Forum – Threads Archive

Isolation Levels

Is there anyway of outputing from a storedproc what the current isolation level is? i.e. inserting into a table or "print" the current isolation level each time a stored proc is called. Thanks

---

Yes there is. set transaction isolation level read uncommitted
DBCC USEROPTIONS
set transaction isolation level read committed Bambola.

---

Thanks for statement, is there anyway I can output this in realtime to a table?

---

create table trans_isolation (set_option varchar(100), value varchar(100), date_ins datetime default getdate()) set transaction isolation level read uncommitted
insert into trans_isolation (set_option, value)
EXEC (‘DBCC USEROPTIONS’) set transaction isolation level read committed Bambola.

---

Thanks

---

]]>