ADODB with NOLOCK

• PPC Guru

  SSC Veteran

  Points: 270

  More actions

  January 23, 2008 at 10:12 am

  #378130

  Hi All,

  I have several somewhat complex views that I use to both retrieve data and to grab a blank record when adding a new row to an entity. The views use "WITH (NOLOCK)" for performance and I was wondering if when I create a DB connection using pessimistic/optimistic locking if when I use the view the tables/row is actually getting locked.

  Does the ADODB lock override the "WITH (NOLOCK") syntax in hte SQL or vice-versa?

  Thanks in advance,

  Michael

• antonio.collins

  SSCrazy Eights

  Points: 9600

  More actions

  January 23, 2008 at 3:55 pm

  #771095

  the view's DDL NOLOCK will override any connection/session locking.