According to the BOL:
@@CONNECTIONS - Returns the number of connections, or attempted connections, since Microsoft® SQL Server™ was last started.

@@MAX_CONNECTIONS - Returns the maximum number of simultaneous user connections allowed on a Microsoft® SQL Server™.

This should give you the number of user connections:

select COUNT(*) from master.dbo.sysprocesses where hostname > ''

-Mike