• sp_who2 'active' returns all the active connections which are runnable.

    If there is an application with a connection pool of 25 connections but is no queries are being execute via these connections then you wont see those in sp_who2 active but you can find them in sysprocesses.

    For all the connections, i would see

    select * from sysprocesses where spid > 50