Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the number of attempted connections, either successful or unsuccessful since SQL Server was last started.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
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.
@@MAX_CONNECTIONS is the maximum number of connections allowed simultaneously to the server. @@CONNECTIONS is incremented with each login attempt, therefore @@CONNECTIONS can be greater than @@MAX_CONNECTIONS.
Examples
The following example shows returning 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
---------------------- --------------
3/27/2005 10:32:45 AM 218179
See Also
Reference
System Statistical Functions (Transact-SQL)
sp_monitor (Transact-SQL)