Post reply

Isolation Levels

  • October 5, 2012 at 5:24 am

    #262628

    Hi All

    I'm struggling to understand the READ_COMMITTED_SNAPSHOT isolation level.

    If I have a database with the READ_COMMITTED_SNAPSHOT isolation level turned on and I execute a query that starts with set transaction isolation level read uncommitted

    Does my query override the database isolation level setting?

    Thanks

  • October 5, 2012 at 5:29 am

    #1545997

    Yes, you can

  • October 5, 2012 at 7:15 am

    #1546057

    SQLSACT (10/5/2012)

    Hi All

    I'm struggling to understand the READ_COMMITTED_SNAPSHOT isolation level.

    If I have a database with the READ_COMMITTED_SNAPSHOT isolation level turned on and I execute a query that starts with set transaction isolation level read uncommitted

    Does my query override the database isolation level setting?

    Thanks

    Yes, specifying isolation level explicitly will override the default behavior.

    Sujeet Singh

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

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