Post reply

ROWLOCK

  • March 20, 2013 at 3:05 am

    #1598780

    Sure you can change the isolation level in a trigger. The new isolation level takes effect from that point until it's set to something else. Isolation level specified by SET TRANSACTION ISOLATION LEVEL overrides whatever the app specified.

    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

  • March 20, 2013 at 3:12 am

    #1598781

    Thanks much

  • March 21, 2013 at 9:15 am

    #1599438

    I note that some form of index on ID should probably be in place here to help both with concurrency and performance.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 3 posts - 16 through 17 (of 17 total)

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