Post reply

Check Server Transaction Isolation Level

  • August 28, 2003 at 6:24 pm

    #106990

    Hello, how can I check the current transaction isolation level for the server? Thanks!

    Edited by - tikus on 08/28/2003 6:25:19 PM

  • August 28, 2003 at 9:21 pm

    #471906

    Hi there

    Remember that transaction isolation is per connection, and not set globally.

    For a user connection, consider the command DBCC USEROPTIONS. I cant remember the exacte issues, but from memory READ COMMITTED (default) is not shown, if you alter this then user options will return the mode.

    There may be another way via the sys tables (and combination of) but have yet to fully check this.

    Cheers

    Ck

    Chris Kempster

    http://www.chriskempster.com

    Author of "SQL Server 2k for the Oracle DBA"


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

  • August 29, 2003 at 10:37 am

    #472011

    Thanks a lot, Chris!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply