Post reply

Scope of Isolation Levels?

  • October 21, 2010 at 3:37 am

    #143771

    Scope of Isolation Levels

  • October 21, 2010 at 4:03 am

    #1240136

    Can you clarify your question please?

    Have you looked at the entry for SET TRANSACTION ISOLATION LEVEL in SQL Books Online/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 21, 2010 at 4:50 am

    #1240162

    Hi,

    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

    Go

    Waitfor TIME '14:16:00'

    begin

    SELECT * FROM employeeee WHERE EmpID ='mp3661' ----120000

    end

    In the above scenario what is the scope of READ UNCOMMITTED ISOLATION LEVEL?

    Is Isolation level Scope Table Level or Connection Level Or Data Base Level.

    I am new to Isolation

    Levels.

    Thanks,

    IRK

  • October 21, 2010 at 5:03 am

    #1240173

    GilaMonster (10/21/2010)

    Have you looked at the entry for SET TRANSACTION ISOLATION LEVEL in SQL Books Online?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 4 (of 4 total)

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