DaveP (an*******@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,
es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx