Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2006-07-20 : 15:23:48
|
| Hi all,just wanted to know that why current acitivty in SQL 2000 would time out while refresh!! i tried sp_lock and there is no lock exist at all!!Please advise.!!Thanks |
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2006-07-20 : 16:12:20
|
| Try running sp_who and sp_who2 with Query Analyzer. If that works fine it something with your client.- Eric |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-20 : 21:56:17
|
| the current activity monitor is a gui since it is on the enterprise manager, use query analyzer, otherwise, verify if there are deadlocks and nasty blocks presenthope this helps--------------------keeping it simple... |
|
|
|
|
|
|
Current Activity time out