@@CONNECTIONS (T-SQL)

Returns the number of connections or attempted connections since Microsoft® SQL Server™ was last started.

Syntax

@@CONNECTIONS

Return Types

integer

Remarks

Connections are not the same as users. Applications, for example, can open multiple connections to SQL Server without the user being aware of these 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 made 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

See Also