How To Grant and Revoke the Permission

Open a query window in SQL Server 2005 Management Studio and execute the following statement.

		-- Grant
		GRANT VIEW SERVER STATE TO << login name >>
		
		-- Revoke
		REVOKE VIEW SERVER STATE FROM << login name >>
	

How To View SQL Server 2005 Activity Monitor?

In SQL Server Management Studio, connect to the server with Object Explorer, expand Management, and then double-click Activity Monitor.