SQL Server Performance

Max Connections

Discussion in 'Getting Started' started by rao, May 17, 2007.

  1. rao New Member

    Hi

    Greetings


    Could you let me know the Maximum No of Connection can be opened in SQL Server 2000 Please?

    thanks a lot in advance.
    Rao
  2. FrankKalis Moderator

    32,767. In MSDE it is limited down to 10 or so, I think.

    --
    Frank Kalis
    Moderator
    Microsoft SQL Server MVP
    Webmaster:http://www.insidesql.de
  3. shashank sharma New Member

    http://msdn2.microsoft.com/en-us/library/aa196730(SQL.80).aspx

    explains you clearly

    Dont go on my posts iam still a student (*_*)
  4. rao New Member

    Excellant. Thanks a lot to Forums

Share This Page