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 code snippet below shows the maximum number of user connections allowed by the current SQL Server. Refer to our SQL tutorial page.

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 SQL sp_configure system SQL stored procedure instead of @@MAX_CONNECTIONS.