Sql-server – Sql Server 2005 Connection Limit

sql-serversql-server-2005

Is there a connection limit on Sql Server 2005 Developers Edition. We have many threads grabbing connections, and I know ADO.NET does connection pooling, but I get OutOfMemory exceptions. We take out the db connections and it works fine.

Best Solution

This is the response to that question on Euan Garden's (a Program Manager for Visual Studio Team Edition) blog:

There are no limits in terms of memory, db size or procs for DE, it is essentially Enterprise Edition. There is however a licensing restriction that prevents it from being used in production.

Therefore, you probably just need to make sure you are closing your connection objects properly. The using block will be perfect for such a job...