Home Forums SQL Server 2008 SQL Server Newbies Query over slow connection, when are locks released? RE: Query over slow connection, when are locks released?

  • January 21, 2014 at 7:44 am

    #1681917

    Close enough. Shared locks are released no later than the end of the query (assuming default isolation level), exclusive locks are held til the end of the transaction

    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