johnf23
asked on
How to remove idle connections from SQL Server 2005
I have a web application which connects through application server to a SQL SERVER 2005 database. The problem is that after users login to database ( through AppServer, not directly from the Web Site ) and after some time the exit Web Browser window without normal logout process, then there are a lot of connections in SQL Server and they must be dropped. Is there way or parameter to poll idle connections and kill from the SQL Server 2005 ? Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER