@@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

One Reply to “USING @@MAX_CONNECTIONS VARIABLE”

  1. dear
    @@MAX_CONNECTIONS is not working in sql azure so can we give another query for sql azure

    Saraswati pg college

Leave a Reply to Sunil Cancel reply

Your email address will not be published. Required fields are marked *