>In version 6.5, each connection that is allocated requires roughly 40K, which is allocated from the heap when SQL Server starts. It is not released until SQL Server is shutdown.
So, if we have 50 new users working on the Web site every hour, this means 2 megs, it would mean that after a few days, SQL Server might run out of memory.