Open a query window in SQL Server 2005 Management Studio and execute the following statement.
GRANT VIEW SERVER STATE TO << login name >>
REVOKE VIEW SERVER STATE FROM << login name >>
In SQL Server Management Studio, connect to the server with Object Explorer, expand Management, and then double-click Activity Monitor.
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add firstname.lastname@example.org to your trusted senders list in your email software.