Home Forums SQL Server 2005 SQL Server Newbies How To Determine The Number of Open Connections In Sql Server 2000 RE: How To Determine The Number of Open Connections In Sql Server 2000

  • December 4, 2012 at 11:51 pm

    #1565579

    SELECT

    COUNT(dbid) as TotalConnections

    FROM

    sys.sysprocesses

    WHERE

    dbid > 0

    If more information is required

    use

    sp_who2 'ACTIVE'