killing processes through procedure

Last Post 06 Feb 2007 12:56 AM by malikwn. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
malikwn
New Member
New Member

--
06 Feb 2007 12:22 AM
Hi All,

I want to kill certain processes / connections that are available in a list in the application. For this I require to have certain procedure to which information will be passed and based on that it'll kill multiple processes / connections for the database - sort of remote connection management.

I couldn't find any statement other than kill, but it doesn't accept any variable, nor does it run within execute statement.

Can any body tell for a way to kill a process/connection through procedure or you may say dynamically?

Waiting for response !!!

Kind Regards...
malikwn
New Member
New Member

--
06 Feb 2007 12:56 AM
Sorry - my bad

Please ignore

My script was originating error in execute - trying to kill some SPIDs less than 51 and also the self connection. Saw another thread and found that check be added for less than 51.
SQLUSA
New Member
New Member

--
22 Feb 2007 09:33 PM
Can you post your script?

Also you can detach the database and attach it.

Kalman Toth
SQLUSA: htpp://www.sqlusa.com


Acceptable Use Policy
---