@@CONNECTIONS
SQL Server 2000
Returns the number of connections, or attempted connections, since Microsoft® SQL Server™ was last started.
Syntax
@@CONNECTIONS
Return Types
integer
Remarks
Connections are different from users. Applications, for example, can open multiple connections to SQL Server without the user observing the connections.
To display a report containing several SQL Server statistics, including connection attempts, run sp_monitor.
Examples
This example shows the number of login attempts as of the current date and time.
SELECT GETDATE() AS 'Today''s Date and Time',
@@CONNECTIONS AS 'Login Attempts'
Here is the result set:
Today's Date and Time Login Attempts
--------------------------- ---------------
1998-04-09 14:28:46.940 18
