sa spid - need to kill - server hanging

Hi

I attempted to add a column to a table containing around 10 million
rows (will do it differently next time :-) and ever since the server
has been hanging and only occassionally can you connect to it and do
anything with it. It all seems to be hinging on a process that is
running as sa user I wasn't logge in as sa though), which I can't kill.
Restarting the SQLServer service and even rebooting the box has no
effect - the process is still there and continues to hog around a gig
of ram and counting and performing endless disk io.

I can't intervene in anyway, it seems. I tried to drop the table that
it all started from, but I cancelled this operation after about 30
minutes. The server has been in this state for around 3 hours now and
not sure how to resolve. The database is dispensible - I can simply
restore from back up so would be happy to drop it but this seems
impossible.

Any suggestions how to stop this rogue process.
Using SQLServer 2000, latest SP.

Glenn

.

Relevant Pages

  • Re: SQL Service account rights
    ... there's any likelihood the server will be accessed by a web server. ... (xp_cmdshell runs with the authorities granted to the SQLServer service, ... > I'd like to hear everyone's opinion on what rights a SQL server & SQL ...
    (microsoft.public.sqlserver.security)
  • Re: sa spid - need to kill - server hanging
    ... When you stop the server service, the 'rogue' process will be aborted. ... Restarting the SQLServer service and even rebooting the box has no ...
    (microsoft.public.sqlserver.security)
  • Re: HELP! Ive been had! Someone hacked into my Linux box. What now?
    ... server that is using a default sshd configuration. ... As of now it is still rebooting at 9:00 AM. ... been "rootkitted" (the standard way of hijacking a server). ... Rootkits ...
    (comp.os.linux.security)
  • Re: Troubleshoot Failing Clients Internet Connection
    ... rebooting no problems with clients connecting to the interner on Tuesday and ... I plan to remove the card this weekend. ... How many nics in your SBS server? ... Internet when they first logon in the morning. ...
    (microsoft.public.windows.server.sbs)
  • Re: save and sound operating system
    ... One is a short-term solution. ... totally automatically, just rebooting a workstation ... but a stand-alone server (especially Web ... operating system. ...
    (microsoft.public.windowsxp.security_admin)