Kill a process

I have an purchased application that keeps hanging up. I don't have the
source code. If I stop and start SQL Server it frees up.
Question; if I run the sp_who2 stored procedure in query analyzer and see an
id that is blocking; how can I cancel a pid from query analyzer?
Thanks in advance,
Joe in FLoridaKILL <spid>
"FloridaJoe" <noneavailable@.hotmail.com> wrote in message
news:uO1WmKXrFHA.3060@.TK2MSFTNGP09.phx.gbl...
>I have an purchased application that keeps hanging up. I don't have the
> source code. If I stop and start SQL Server it frees up.
> Question; if I run the sp_who2 stored procedure in query analyzer and see
> an
> id that is blocking; how can I cancel a pid from query analyzer?
> Thanks in advance,
> Joe in FLorida
>|||KILL <spid>
BG, SQL Server MVP
www.SolidQualityLearning.com
"FloridaJoe" <noneavailable@.hotmail.com> wrote in message
news:uO1WmKXrFHA.3060@.TK2MSFTNGP09.phx.gbl...
>I have an purchased application that keeps hanging up. I don't have the
> source code. If I stop and start SQL Server it frees up.
> Question; if I run the sp_who2 stored procedure in query analyzer and see
> an
> id that is blocking; how can I cancel a pid from query analyzer?
> Thanks in advance,
> Joe in FLorida
>|||See "kill" in BOL.
AMB
"FloridaJoe" wrote:

> I have an purchased application that keeps hanging up. I don't have the
> source code. If I stop and start SQL Server it frees up.
> Question; if I run the sp_who2 stored procedure in query analyzer and see
an
> id that is blocking; how can I cancel a pid from query analyzer?
> Thanks in advance,
> Joe in FLorida
>
>|||KILL SPID
e.g.
KILL 69
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"FloridaJoe" wrote:

> I have an purchased application that keeps hanging up. I don't have the
> source code. If I stop and start SQL Server it frees up.
> Question; if I run the sp_who2 stored procedure in query analyzer and see
an
> id that is blocking; how can I cancel a pid from query analyzer?
> Thanks in advance,
> Joe in FLorida
>
>