SQL @@MAX_CONNECTIONS is one of the Configuration Function, which will return the maximum number of user connections that are allowed by the currently installed SQL Server. Syntax behind this is
SQL @@MAX_CONNECTIONS Example
Below code snippet will show you the maximum number of user connections that are allowed by the current SQL Server.
SELECT @@MAX_CONNECTIONS AS 'Maximum Connections'
If you don’t know the minimum and maximum connections that are allowed, or if you want to limit them, then use sp_configure system stored procedure.
Thank You for Visiting Our Blog