locking mechanism

• HendraEP

  Mr or Mrs. 500

  Points: 515

  More actions

  December 4, 2001 at 8:03 pm

  #257916

  what is a standard locking mechanism in sql server 2000? is it a pagelock or a rowlock ?

  and if i access sql server from client side application ( like vb ), what locking mechanism it's used? because as far as i know the lowest locking mechanism in vb is pagelock

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738112

  More actions

  December 4, 2001 at 10:32 pm

  #420756

  SQL 2000 will use the lowest lock it thinks it needs. For a single row insert, this will be a row lock. For multi rows, it might be a page, range, or table lock.

  Steve Jones

  steve@dkranch.net