Results 1 to 2 of 2

Thread: Viewing isolation level from outside of a connection

  1. 03-03-2003, 09:27 AM #1
    John Shahan
    John Shahan is offline Registered User
    Join Date
    Oct 2002
    Posts
    34

    Viewing isolation level from outside of a connection

    Is there any way to confirm the isolation level of a given connection from outside of the connection itself?

    As far as I can see, DBCC USEROPTIONS only returns information regarding the current connection.

    I am troubleshooting a locking issue and it would be very helpful to me if I could check the isolation level of any given connection.

    Thanks in advance for any help.
    Reply With Quote Reply With Quote
  2. 03-03-2003, 01:01 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    I am not 100% sure but you could try tracing with Profiler
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules