Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Lock Request time out period exceeded Expand / Collapse
Author
Message
Posted Sunday, September 06, 2009 8:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 19, 2013 1:27 AM
Points: 31, Visits: 179
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.

Post #783476
Posted Tuesday, September 08, 2009 8:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, December 04, 2009 5:42 AM
Points: 32, Visits: 76
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 )
Post #784275
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse