title: How to achieve functionlity i.e. controlling "Incr Pool Size" or "Decr Pool Size" while establishing connection to SQL? similar to ORACLE
body: <p>I have asked a question about "Incr Pool Size" or "Decr Pool Size"</p>
  
  <p><a href="https://stackoverflow.com/questions/11427362/how-to-resolve-sqlconnection-error-keyword-not-supported-decr-pool-size/11427442#comment15077277_11427442">How to resolve SqlConnection error &quot;Keyword not supported: &#39;decr pool size&#39;.&quot;</a></p>
  
  <p>This is another but different question related to that , in brief ORACLE connection string provides these two option to increase/decrease connection objects when connection pool is empty or full respectively. how can we achieve this with SQL.</p>
  
  <p>EDIT: Why I want to know because I am creating a middleware where I am writing to database using multiple parallel threads (e.g. 60), what I am thinking is when all my connections from pool (e.g. 50) are in use and new bunch of threads try to create connection will sql server will create another bunch of connection in pool i.e. 50 or will it create this exceeding connection one by one?</p>