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.

>> How come SQL Server allowed us to change a value if the memory value was not high enough?

I'm guessing that SQL Server really has no way of telling that the new configuration parameters will affect the server until startup.

-Mike