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".