Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


Returns the number of attempted connections, either successful or unsuccessful since SQL Server was last started.

Topic link iconTransact-SQL Syntax Conventions


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.

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
---------------------- --------------
12/5/2006 10:32:45 AM  211023       

Community Additions

© 2016 Microsoft