Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    17

    Unanswered: Change default rowlock on SQL Server

    Hello!

    Does anyone know if there is a setting on MS SQL server to tell it to always lock a row for updating when attemping to change a record? I have a program that does a select statement and the user can then choose which records to edit. Once they select to edit a record, I need the sql server to prevent other users from editing that record. I know I can use the 'Updlock' hint but was hoping there was just a default setting on the server I could change. Thank you!

  2. #2
    Join Date
    Apr 2002
    Posts
    31
    In SQL2K row locking is default, if more locks required, this could escalate to page lock or full table lock. In SQL2K there is no way to change this behavior except using hints or isolation level, you can play also with indexes to obtain key locks and with cursor modes.

    HTH,
    OBRP

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Also refer thru books online for LOCKS topic which has been explained.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •