Kill connection

[DaveP]

Hello,
I do maintenance on the Back end
and have like 10 - 20 connections open...speciali zed 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...ca use server still has the pool of the connection...i
want to kill the pool'd connection also

thanks
Dave P

[Erland Sommarskog]

Re: Kill connection

DaveP (analizer1@yaho o.com) writes:

I do maintenance on the Back end
and have like 10 - 20 connections open...speciali zed 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...ca use 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@sommarsk og.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