USING @@CONNECTIONS VARIABLE

@@CONNECTIONS Variable contains the number of connections that were called on to the SQL Server Service.
This number includes both Successfull and unsuccessful connections.
Basic Syntax for using @@CONNECTIONS:


SELECT @@CONNECTIONS

 

Output for the Above query would give the following depending up on your server:

 

Leave a Reply

Your email address will not be published. Required fields are marked *