Getting an Error lock time exeeded.

• AMIT GUPTA-263376

  SSCarpal Tunnel

  Points: 4244

  More actions

  July 3, 2006 at 3:14 am

  #75006

  Hi,

  I am creating a table in query analyzer and after creating such table when i open the EM (Enterprise Manager) ,I click on tables it don't show any table and raises an error : Lock Time Exeeded to its limit.

  Pls. Provide a solution for it.

  Regards,

  Amit Gupta

• Jens Süßmeyer

  SSC Enthusiast

  Points: 165

  More actions

  July 3, 2006 at 4:42 am

  #647157

  Look in the current acitivity window of EM. You will see who is actually blocking the access to the table. It seems that someone is locking it.

  HTH, Jens Suessmeyer.

  ---

  http://www.sqlserver2005.de

  ---

• Jo Pattyn

  SSC-Dedicated

  Points: 32352

  More actions

  July 3, 2006 at 4:50 am

  #647160

  You can also figure it out with sp_who,sp_who2,sp_lock.

  The client tools version matches the sql server version (in terms of servicepacks)?

• James Luetkehoelter

  SSCommitted

  Points: 1733

  More actions

  July 3, 2006 at 7:01 am

  #647176

  Agreed, it's probably a blocking situation, but a memory constrained machine can give the same sort of response. Just thought I'd through that in...