USING @@MAX_CONNECTIONS VARIABLE

@@MAX_CONNECTIONS Returns the maximum number of simultaneous user connections allowed on an instance of SQL Server. The number returned is not necessarily the number currently configured.

Syntax:


SELECT MAX_CONNECTIONS

Output for the Above query would give the following depending up on your server:

Return Type of @@MAX_CONNECTIONS is integer