Re: Kill process

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Justin Drennan (justin_at_nospam.com)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 20:57:40 +0200

Thanks for the help guys,

The Sp was callign xp_cmdshell, which in turn was executing a BCP. I will
use task manager and let you guys know!

Thanks for the help!!

:)

"Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> wrote
in message news:uSSHNSgsEHA.3508@TK2MSFTNGP14.phx.gbl...
> That won't time out.
>
> Is there any external process created by the stored procedure (via
> xp_cmdshell or sp_OACreate)? You can then kill that process in Windows
Task
> Manager, which might solve your problem.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
>
> "Justin Drennan" <justin@nospam.com> wrote in message
> news:5pmdnZvX3ZssBfPcRVn-pA@is.co.za...
> > Hi Jacco,
> >
> > The stored proc was executed by a user, and the user has rebooted the
> > machine. The process shows: KILLED/ROLLBACK and is 0% complete in the
last
> > 3
> > hours....
> >
> > Will this eventually time out?
> >
> > The problem is, that this is causing locks on my server, which I am
unable
> > to resolve. I am also not able to restart the SQL server as there are
> > hundreds of users which would be impacted....
> >
> > thanks
> >
> > "Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid>
> > wrote
> > in message news:%23o05WAgsEHA.2072@tk2msftngp13.phx.gbl...
> >> You can kill the client process that created the SQL Server connection.
> > For
> >> example, if the stored procedure was started by a job, you can stop and
> >> restart SQL Server Agent to clear the process and release the locks.
> >>
> >> --
> >> Jacco Schalkwijk
> >> SQL Server MVP
> >>
> >>
> >> "Justin Drennan" <justin@nospam.com> wrote in message
> >> news:nKWdncdZZ6y9F_PcRVn-og@is.co.za...
> >> >I have a stored proc which outputs data to a .csv.
> >> >
> >> >
> >> >
> >> > The process had a problem and had to be killed. Once killed, the
> >> > process
> >> > begins rolling back. However the rollback is 0% and unknown amount of
> > time
> >> > until successful. When I delete .csv files, they are re-created,
within
> >> > seconds by the SQL server, which i find strange.
> >> >
> >> >
> >> >
> >> > The problem is, these processes, which are being killed now have
locks
> > on
> >> > the Master DB, and I dont know how to kill them!
> >> >
> >> >
> >> >
> >> > Help!
> >> >
> >> >
> >> >
> >> > thanks,
> >> >
> >> > Justin
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Stored procedure does not complete until result set is retrieved from ODBC
    ... I have a SQL Server Stored procedure that I am executing via ODBC. ... -- Start Code without cursor ...
    (microsoft.public.sqlserver.odbc)
  • Re: Maintenance plan
    ... Executing the query "EXECUTE master.dbo.xp_delete_file ... After the maintenance run at the end when it has to delete old backup ... What is logged in the job history, SQL Server or Windows logs? ... The message was checked by ESET NOD32 Antivirus. ...
    (microsoft.public.sqlserver.server)
  • Re: Access while running DTS package using stored procedure
    ... The permissions when executing xp_cmdshell can be different depending on who ... which the SQL Server service is running. ... > I wrote a DTS Package that can take the data from a .txt file residing ... > Declare @RunDTS as varchar ...
    (microsoft.public.sqlserver.dts)
  • Re: updating through a loop statement
    ... The optimizer can, and will, execute statements out of order if it detects that they are not co-dependent. ... This behaviour is easily observable if you debug SQL server, and I was also bitten by a bug in the 2008 optimizer when it over optimized the statement execution of a very aggressive app using a certain ODBC call sequence to reduce server workload ... I suspect that he should replace the loop in his sp (multiple update statements) with either dynamic SQL or a single update statement depending on whether he knows in advance all of the fields that he needs to update or not. ... stored procedure is executing, no other statement in the procedure is ...
    (microsoft.public.sqlserver.programming)
  • Re: Database Growth & Space Recovery Problem
    ... but the sysindexes info is ... Wayne Snyder, MCDBA, SQL Server MVP ... > build havinf nvText Field with large no of records. ... After Executing the Shrink Database from Enterprise Manager. ...
    (microsoft.public.sqlserver.datawarehouse)