Post reply

Maximum connections

  • January 11, 2010 at 8:47 am

    #141596

    Generally how many connections allowed by SQL Server 2005 at a time. How do we know that? Is max conn depends on anything

    Please clarify on this. Thanks!

  • January 11, 2010 at 8:52 am

    #1101860

    Maximum connections are limited to 32,767 for both SQL 2008 and SQL 2005 and you can edit that from your server properties tab, but I do not suggest you modify it unless otherwise there is a specific need for a dedicated connection.

    I suggest you do a thorough reading on BOL or try to google it before you make any changes..

    HTH...

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply