Results 1 to 5 of 5

Thread: MSSQL 2005 Activity Monitor

  1. 11-01-2007, 01:39 PM #1
    ecka00
    ecka00 is offline Registered User
    Join Date
    May 2005
    Posts
    111

    MSSQL 2005 Activity Monitor

    What is the least amount of access I need to grant a login for access to run Activity Monitor from SQL Management Studio?
    Reply With Quote Reply With Quote
  2. 11-01-2007, 03:45 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can let user use sp_who2 instead, no special permission required.
    Reply With Quote Reply With Quote
  3. 11-02-2007, 07:45 AM #3
    ecka00
    ecka00 is offline Registered User
    Join Date
    May 2005
    Posts
    111

    still require an anser to original Q

    I appreciate the suggestion however, I still need an answer to the original question. Is sysadmin the minimum or is there something less "God" like?
    Reply With Quote Reply With Quote
  4. 11-02-2007, 11:08 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Need be member of processadmin role.
    Reply With Quote Reply With Quote
  5. 11-02-2007, 01:27 PM #5
    ecka00
    ecka00 is offline Registered User
    Join Date
    May 2005
    Posts
    111

    Smile as per usual--thank you rmiao

    thank you thank you
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules