Post reply

Users connected to SQL Server

  • October 26, 2005 at 4:48 am

    #89708

    Hi all,

    I want to know how do we find the no of users accessing SQL server.Also help me how to find no of users accessing each DB.Preferably some system stored procedure.

    vamsi

  • October 26, 2005 at 7:12 am

    #600119

    INSERT (table) EXEC sp_who

    Just need to work out your table DDL

    Once in your table, query to group on dbname and count(*) etc...

  • October 27, 2005 at 10:38 am

    #600677

    If you use sp_who/sp_who2, examine the SPID column. SPIDs less than 50 are almost always SQL Server system processes. So for a true connection count for licensing you may want to omit these.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply