NOWAIT

• Lucas-187953

  Newbie

  Points: 1

  More actions

  December 1, 2004 at 11:25 pm

  #65327

  Hi,

  any body know, how to identified the records/table is locking in select/update statement ?

  in oracle i can used nowait command, so if the record/table is locking, i will get error message/exception during update the records.

  any similar comand for nowait ?

  or any procedure to identified the record/table is locking ?

  please....

  Regards,

  paracio

   

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  December 2, 2004 at 5:31 am

  #532169

  There is NOWAIT in SQL Server as well.

  Also have a look at procedures

  sp_who, sp_who2, sp_lock, sp_lock2

  Books On Line has more info on all above. (except the sp_xxx2 variants)

  /Kenneth