Logo 
Search:

SQL Server Articles

Submit Article
Home » Articles » SQL Server » Configuration FunctionsRSS Feeds

@@MAX_CONNECTIONS - MAX_CONNECTIONS Function

Posted By: Sarita Patel     Category: SQL Server     Views: 2427

This article explains about @@MAX_CONNECTIONS function in sql server with examples.

@@MAX_CONNECTIONS function is used to get maximum number of simultaneous user connections allowed on sql server. 

The actual number of user connections allowed also depends on the version of SQL Server installed and the limitations of your applications and hardware.

To reconfigure SQL Server for fewer connections you can use sp_configure. The number returned is not necessarily the number currently configured. 


Syntax of @@MAX_CONNECTIONS Function :

@@MAX_CONNECTIONS

Return type of @@MAX_CONNECTIONS function is integer.



Examples of @@MAX_CONNECTIONS Function :

Example 1 : Use of @@MAX_CONNECTIONS function in select clause

SELECT @@MAX_CONNECTIONS

Output
32767

Above example returns number of simultaneous user connections allowed on sql server. 
  
Share: 


Didn't find what you were looking for? Find more on @@MAX_CONNECTIONS - MAX_CONNECTIONS Function Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of @@MAX_CONNECTIONS - MAX_CONNECTIONS Function is from United States.
 
View All Articles

Related Articles and Code:


 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!