how to disconnect a connection to a hostname from sql server 1

[shresthaal]

I have a bunch of processes that are sleeping and waiting for command from a computer that is connected to the sql server through a java program. The program runs queries on the server and most of the time the SPID associated with this program is blocked or locked. I do not have access to the computer but if I wanted to block these processes from this computer how would I do it.

 

[NoCoolHandle]

There is the Kill statement.

Permissions needed are sysadmin
Parameter = spid

kill 9877

HTH

Rob

 

[shresthaal]

well i know how to kill the spid id but how do i block a specific connection from a hostname

 

[NoCoolHandle]

scan the sysprocesses table for host_name = X then kill the spid

 

[NoCoolHandle]

well i know how to kill the spid id but how

What am i supposed to be a fng mind reader?

Sorry, I will ignore any more posts from you.

NOCOOL!

 

[shresthaal]

my bad just looking for help amateur at work would appreciate further help