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 Name | Max Connections |
---|---|
TEST | 32767 |
See also:
T-SQL Functions ->
@@CONNECTIONS