Hi Brian,

I am facing a similar problem in my project - I don't see the issue in development, but when we move to production the number of sleeping connections grow rapidly and sql server starts refusing new connections (the software is pretty useless at this stage).

You mention that after closing, sql server holds the connection for a period of time (1 min or so). Is there any documentation that gives this information and also any idea whether this number is tunable/Changeable ?

thanks

Anand