SP_WHO / DB Sessions

Discussion in 'Databases' started by TANNE05, Dec 20, 2007.

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

    TANNE05

    Hi,

    I want to identify the number of users connected (active & inactive)to my database.

    I have tried to use the SP_WHO command without success (there appears to be a privilege issue?).

    Any advice would be appreciated.

    Thanks
    Paul
     
    TANNE05, Dec 20, 2007
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    Paul

    You can try accessing the processes from the master database:

    change to use the master database:
    use master;
    go
    select * from sys.sysprocesses where loginame = '<sql user name>' - sql 2005

    select * from sysprocesses where loginame = '<sql user name>' -sql 2000


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Dec 20, 2007
    #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