"Timeout Expired" when trying to see table records 1

[royc75]

Hello,

I have a Database with many tables in it.
Lately I encountered a problem that I can't open many of the tables there. If I try to see the records at the table through the EM, even if it contains 2-3 records it waits and waits until I receive "Timeout Expired" error. Why is that and how can repair it?

 

[mrdenny]

Sounds like another user has taken a lock on the tables are you are being blocked. When this happens open up Query Analyzer and run sp_who2 and see who is blocking you, and what query they are running.

You'll then need to resolve the locking issue that the other user is creating.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[royc75]

Hello Denny,

I've run the sp_who2 and I get a table with the information. How can I see there if and where I am being blocked?

 

[royc75]

Got it! It's at the BlkBy column, 10X Dennis.