T-SQL Tutorial

T-SQL @@Max_connections


Is an configuration function and return the maximum number of user connections allowed on an SQL Server instance.

@@Max_connections Syntax

@@MAX_CONNECTIONS;

@@Max_connections Example

SELECT @@SERVERNAME AS 'Server Name',
@@MAX_CONNECTIONS AS 'Max Connections';

Server NameMax Connections
TEST32767

See also:
T-SQL Functions -> @@CONNECTIONS