@@CONNECTIONS

Transact-SQL Reference

Transact-SQL Reference

@@CONNECTIONS

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

See Also

Configuration Functions

sp_monitor