Home Forums SQL Server 7,2000 T-SQL How To Lock in Sql Server 2005 The record When It access by Other Person? RE: How To Lock in Sql Server 2005 The record When It access by Other Person?

  • September 15, 2008 at 1:50 am

    #871613

    SQL Server does that automatically. If a user is updating a row then that row is locked exclusive and cannot be read or changed by anyone else.

    Have I misunderstood what you want?

    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