Current Activity Window always times out on Sql Server

I always get this error 1222 time out if I go on my SQL Server and open
Enterprise Manager, go under management, Current acvtivity.

How do I set up SQL server to show me the activity.

The error is (both on server and client)
Error 1222 Lock request time otu period exceeded.

THanks

This is because it switches out of READ UNCOMMITTED about halfway through
for whatever reason. Use sp_who2 in query analyzer instead. If you're
interested in locking/blocking check out aba_lockinfo
http://www.sommarskog.se/sqlutil/aba_lockinfo.html

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"freesoul777" < freesoul777@discussi
ons.microsoft.com> wrote in message
news:74405E36-07ED-4A3A-88D8- 5E407505035E@microso
ft.com...
>I always get this error 1222 time out if I go on my SQL Server and open
> Enterprise Manager, go under management, Current acvtivity.
>
> How do I set up SQL server to show me the activity.
>
> The error is (both on server and client)
> Error 1222 Lock request time otu period exceeded.
>
> THanks
>