BLOCKING

• Jbabington

  SSC Eights!

  Points: 854

  More actions

  March 20, 2002 at 1:59 pm

  #78907

  I am interested in escalating locks to force Deadlocking and also blocking to test a new procedure for detection of such issues... Anyone have reasonable suggestions on how I am most readily able to do this...

  Jbabington
  Jbabington@hotmail.com

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  March 20, 2002 at 2:00 pm

  #425750

  Try starting a transaction, then do a select, then use a waitfor to force a delay.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Jbabington

  SSC Eights!

  Points: 854

  More actions

  March 20, 2002 at 2:30 pm

  #425753

  Thanks Andy...

  Jbabington
  Jbabington@hotmail.com