lock_timeout

• VastSQL

  SSC-Dedicated

  Points: 36101

  More actions

  April 4, 2008 at 6:11 am

  #121374

  Hi all,

  Is there lock timeout option for sql serve 2005r???If so how can i enable that????

• ianT

  SSCrazy

  Points: 2956

  More actions

  April 4, 2008 at 7:04 am

  #798401

  see BOL - "Customizing the Lock Time-Out"

  SELECT @@lock_timeout;

  GO

  SET LOCK_TIMEOUT 1800

  GO

• VastSQL

  SSC-Dedicated

  Points: 36101

  More actions

  April 4, 2008 at 7:22 am

  #798417

  I think this is database level ....And this one comes back to default value when a new query window is opened...