Notification of row lock to a user in case of concurrent update

• Yusuf Bhiwandiwala

  Ten Centuries

  Points: 1298

  More actions

  December 11, 2006 at 11:50 pm

  #118240

  When concurrent updates happen to a row of a table in SQL Server 2000, one user should be notified that row is already locked by some other user. Can this be done? How?

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  December 12, 2006 at 6:38 pm

  #677680

  There is no way to notify the user. The second operation will wait for the first to complete but will provide no notice back to the client.

   

  K. Brian Kelley
  @kbriankelley