Post reply

Record Locking

  • March 23, 2007 at 5:56 am

    #68347

    Hello,

    Can SQL Server 2005 perform record locking? I need to lock the record for a while and release it after some task.

    I want to something similar like "Lock" function in Visual Fox Pro programming.

    All your advice is much appreciated.

    Tee Song Yann

  • March 23, 2007 at 10:11 am

    #696657

    Read about:

    SET TRANSACTION ISOLATION LEVEL    { READ UNCOMMITTED    | READ COMMITTED    | REPEATABLE READ    | SNAPSHOT    | SERIALIZABLE    }[ ; ]
    and select the appropriate setting

  • March 25, 2007 at 7:00 pm

    #696796

    Hii Rookie,

    Thanks for your help.

    Best regards,

    Tee Song Yann

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

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