Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
barmalej
Starting Member
40 Posts |
 Posted - 2006-02-10 : 01:55:33
|
| Hi,Is it possible to get transaction isolation level of each of current connections to SQL server?Thanks in advance.Gennadi |
|
|
mallier
Starting Member
24 Posts |
Posted - 2006-02-10 : 08:55:31
|
| check,dbcc useroptionscheers,http://mallier.blogspot.com |
 |
|
|
barmalej
Starting Member
40 Posts |
Posted - 2006-02-10 : 10:47:20
|
| Thanks,But I want to know this for all active connections, not only for current one.In our situation several different applications in different languages connect to SQL server.Some of them put unexpected locks. So one of things to check if all they have transaction isolation level that they really should have. |
|
|
|
|
|
|
How to GET connection transaction isolation level?