Lock Request time out period exceeded

• Rahul-765886

  SSC Veteran

  Points: 241

  More actions

  September 6, 2009 at 8:59 am

  #209738

  I have application in VB 6.0 and for database i am using SQL Server 2005 Express Edition. Database is located on main server. While opening tables from SQL server management studio i am getting messagebox "Lock Request time out period exceeded" . When i click on OK button , after few seconds the table gets open.

  Can somebody help me about this problem. Does it require ServicePack 2 or 3 (SP2 or SP3). Or it's database problem ? Or i need to do more settings for SQL Server 2005 Express Edition.

  Please refer to the attached image. I image i am opening "Locationwise_Stock table".

  Thanxs.

  [/URL]

• psvirin

  Mr or Mrs. 500

  Points: 542

  More actions

  September 8, 2009 at 8:10 am

  #1050535

  As the first suggestion: try using sp_lock and sp_who stored procedures to find out the information about the locks.

  http://doc.ddart.net/mssql/sql70/sp_la-lz_2.htm

  http://msdn.microsoft.com/en-us/library/aa260384(SQL.80).aspx

  -------------

  StarWind Software developer ( http://www.starwindsoftware.com )