Lock

• sugan

  SSC-Addicted

  Points: 492

  More actions

  June 25, 2008 at 6:18 am

  #93329

  I want to write one SP like,

  before stating migration i want to know anybody lock the tables?

  Because if somebody locking the tables, it cause migration error...

  How to find which user lock the table in the database.....

  This SP SP_lock is not useful for my process .

  Plz give me some tips....

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  June 25, 2008 at 6:26 am

  #833855

  you can Execute system stored procedue [sp_lock]

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  June 25, 2008 at 6:28 am

  #833858

  Alternatively you can use sytem view

  [sys.syslockinfo]

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers