Re: Process Admin Server Role Can't use Kill command

From: Ricky Artigas (ricky_artigas@yahoo.com)
Date: 11/02/02


From: "Ricky Artigas" <ricky_artigas@yahoo.com>
Date: Sat, 2 Nov 2002 21:30:31 +0800


Hi, Kevin! Only sysadmin users can use kill .

;o)
Ricky Artigas

"Kevin Haglund" <khaglund@tileshopsuperstore.com> wrote in message
news:2dc501c281e2$f7415080$37ef2ecf@TKMSFTNGXA13...
> I need to allow some users to kill process that are
> causing blocks. So I created a domain group and added it
> to the process admin server role but these users still
> don't have access to the Kill command in Enterprise
> Manager or through TSQL statements. I couldn't find any
> information on the Kbase and wanted to know if anyone else
> is running in to the same problem. Dose any one know of
> a solution to provide access to the kill command without
> making user SQL Admins?
>
> Thanks
>
> Kevin Haglund
>



Relevant Pages