Dear all,<BR><BR>I knew that each connection should be closed individually after open. I have<BR>situation where SQL connection was opened using ASP and was not closed.<BR>This cause the web server memory usage keep increasing.<BR><BR>My question is that, is there any setting in SQL or command in ASP that<BR>force to close the connection after certain time let&#039s say 10 seconds.<BR><BR>B&#039cos I have noticed that the connections will close itself after certain<BR>time. (I was using the sp_who to monitor it)<BR><BR>Your advice and help is much appreciated.<BR>