Re: Kill Process

From: Alicia (anonymous_at_discussions.microsoft.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 12:26:04 -0700

you can add the status_only clause to Kill.
One question - if it's rolled back 100% but still not ending, is it running something outside of SQL? I.e. something like sp_OaCreate to run a COM component or xp_cmdshell or xp_sendmail?
If that's the case then SQL can lose sight of whether the process is active or not - normally because the dll (or whatever) hasn't reported status back.

Alicia

http://www.sqlporn.co.uk

Relevant Pages

  • Re: User Name Change Problems in WSS
    ... change any user qualities like this, you have to do it in SQL. ... undo, so if you screw up it could kill your site, kill WSS or god forbid, ... > I am running Windows Server 2003 Small Business Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How to kill a process
    ... When you kill a process that has a transaction open, ... It should show up as KILLED/ROLLBACK. ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Orphaned connections
    ... I've found that if you kill a distributed query sometimes the spid will ... linked server to an Oracle box. ... On the SQL box there's a job that ...
    (microsoft.public.sqlserver.server)
  • Re: Identify Lock
    ... Sometimes my users call me and tell me that the system is slow, then I open IPM and I see a lot of users in WAIT state, then I have to identify who is the responsable for the lock and I kill him. ... I run this SQL against imadb to find blocking sessions: ... I have to execute the sql for each DBMS? ...
    (comp.databases.ingres)
  • Re: Process Admin Server Role Cant use Kill command
    ... User does not have permission to use the KILL statement. ... then I'd check what account they are using to log into SQL ... member of the process admin role using IS_SRVROLEMEMBER. ...
    (microsoft.public.sqlserver.security)