'sp_who' on DB

Discussion in 'Databases' started by kieran5405, Feb 25, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. kieran5405

    kieran5405

    Hi,

    I am looking to check the connections hitting my SQL Server 2005 DB.

    UsuallyI would use 'sp_who'...butI am getting a permissions error when I try this on the DB.

    The EXECUTE permission was denied on the object 'sp_who', database 'mssqlsystemresource', schema 'sys'.

    Is there another way to do this??

    Thanks...
     
    kieran5405, Feb 25, 2009
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    you are not allowed to run sp_who or sp_who2 on the server
     
    Bruce, Mar 2, 2009
    #2
  3. afterdeathc

    afterdeathc WillG

    Are there any other options available? In other words, how can I monitor the activity on my database?
     
    afterdeathc, Mar 26, 2009
    #3
  4. JorgeR

    JorgeR DiscountASP.NET Staff

    You can run the command -

    select p.*
    from
    sys.sysprocesses p
    inner join
    sys.sysdatabases d
    on
    d.dbid = p.dbid
     
    JorgeR, Mar 27, 2009
    #4
  5. afterdeathc

    afterdeathc WillG


    Thanks! But unfortunately... When I run that query, the results seem to be limited to the context of the current connection. Is there a way for me to monitor the activity of any/all connections to my database?
     
    afterdeathc, Mar 29, 2009
    #5
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page