Posted by Erland Sommarskog on 02/15/07 22:29

DaveP (analizer1@yahoo.com) writes:
> I do maintenance on the Back end
> and have like 10 - 20 connections open...specialized scrips i run and they
> dont need to be stored proc's
>
> is there a way to kill the connection when the script is finished...from
> my client side..... not just disconnect...cause server still has the
> pool of the connection...i want to kill the pool'd connection also

I'm not sure that I follow. You have a maintenance job that runs from
a client that opens multiple connections?

When the client exits, all pooled connections will go away, since the
pools lives in the process space of the client, not of SQL Server.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]