Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I only see my own connections/processes in the new activity monitor... whereas in the earlier versions of SSMS you could see everyone's. Do I need to change a setting or something?

share|improve this question
    
What permissions / roles do you have on the server? –  squillman Sep 3 '10 at 17:06

1 Answer 1

YOu will need VIEW SERVER STATE permission to view the Activity Monitor in SQL Server 2005 and SQL Server 2008.

Under the processes make sure you have select Login as (All) to show all the processes. BTW do you see any of the system processes?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.