Board index » delphi » killing a MS SQL process

Roberto Martinez

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

killing a MS SQL process

Hi,

I want to kill a MS SQL process but I do know how, do you have a way to
do it,
I want to kill cause some time my App get cycled and dont finish the
execution of a
stored procedure.

Thanks in advance

Roberto Martinez

 
Euan Garde

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:killing a MS SQL process


Take a look at the Kill command in books online, you need to know the spid
of your process before you can kill it.

-Euan

Quote
"Roberto Martinez" <rmart...@hmo.megared.net.mx> wrote in message

news:398F6CC8.C411512F@hmo.megared.net.mx...
Quote
> Hi,

> I want to kill a MS SQL process but I do know how, do you have a way to
> do it,
> I want to kill cause some time my App get cycled and dont finish the
> execution of a
> stored procedure.

> Thanks in advance

> Roberto Martinez

FINISHE

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:killing a MS SQL process


i think its hard to do that thing if you we're using the software itself of
an sql cause the control is on the server.  unless you have a customed
server then it would do.

cheers!
alexis

Quote
"Roberto Martinez" <rmart...@hmo.megared.net.mx> wrote in message

news:398F6CC8.C411512F@hmo.megared.net.mx...
Quote
> Hi,

> I want to kill a MS SQL process but I do know how, do you have a way to
> do it,
> I want to kill cause some time my App get cycled and dont finish the
> execution of a
> stored procedure.

> Thanks in advance

> Roberto Martinez

Roberto Martine

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:killing a MS SQL process


Yeah, Ithink it is hard but how can I abort an operation, when I execute an
stored procedure sometimes
it get cycled.

Thanks in advance

Roberto Martinez

Quote
Euan Garden wrote:
> Take a look at the Kill command in books online, you need to know the spid
> of your process before you can kill it.

> -Euan

> "Roberto Martinez" <rmart...@hmo.megared.net.mx> wrote in message
> news:398F6CC8.C411512F@hmo.megared.net.mx...
> > Hi,

> > I want to kill a MS SQL process but I do know how, do you have a way to
> > do it,
> > I want to kill cause some time my App get cycled and dont finish the
> > execution of a
> > stored procedure.

> > Thanks in advance

> > Roberto Martinez

Other Threads

1. Killing a MS SQL process

2. Kill Process SQL Server 7

3. Killing a long running MS SQL 6.5 query

4. MS-SQL 7: Max DB Process

5. How can I Kill ALL process in WIN32 and Shut down Windows 95/NT

6. Preventing user from killing process under Win95/98

7. Kill a process in Delphi

8. How do i kill a system process?

9. TaskManager - Kill Process ~?!~

10. Killing a process