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

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.