How do I see processes from all users in SSMS2008?

Question

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?

What permissions / roles do you have on the server? – squillman Sep 03 '10 at 17:06 — squillman, Sep 03 '10 at 17:06

score 0 · Answer 1 · edited Oct 05 '15 at 02:28

0

You will need the 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.

By the way, do you see any of the system processes?

edited Oct 05 '15 at 02:28

Falcon Momot

25,244
15
63
92

answered May 12 '11 at 14:40

Satya SKJ

39
3

How do I see processes from all users in SSMS2008?

1 Answers1