SQL @@MAX_CONNECTIONS Configuration Function returns the maximum number of user connections allowed by the currently installed SQL Server. Syntax behind this is
SQL @@MAX_CONNECTIONS Example
The below code snippet shows the maximum number of user connections allowed by the current SQL Server.
SELECT @@MAX_CONNECTIONS AS 'Maximum Connections'
If we do not know the minimum and maximum connections that are allowed. Alternatively, if we want to limit them, use the sp_configure system stored procedure.