locking mechanism

  • 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

  • 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


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

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