SQL @@MAX_CONNECTIONS 1

SQL @@MAX_CONNECTIONS

SQL @@MAX_CONNECTIONS Configuration Function returns the maximum number of user connections allowed by the currently installed SQL Server. Syntax behind this is

@@MAX_CONNECTIONS

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'
SQL @@MAX_CONNECTIONS 1

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.

SQL @@MAX_CONNECTIONS 2