Monitoring users

Discussion in 'Databases' started by androoo, Dec 11, 2005.

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

    androoo

    Hi I need to be able to monitor active connections to test that connection pooling is working effectively.
    As i dont have permission to run sp_who is there another way to look at the database connections?

    Thanks, A
     
    androoo, Dec 11, 2005
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    You can accomplish this by querying the master..sysprocesses and searching for your database name in your select statement


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Dec 13, 2005
    #2
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