Post reply

locking mechanism

  • 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

  • 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

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

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