Re: Server Roles Process administrators

From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
Date: Wed, 22 Feb 2006 16:32:11 -0500

Because you have to be either in the sysadmin or processadmin roles to use
KILL.

--
Andrew J. Kelly SQL MVP

"Patrick" <Patrick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0F5E2859-4F3C-45AE-AF3A-C63A34A8967D@xxxxxxxxxxxxxxxx

SQL 2000 SP4

In SQL manager the option Kill Process stay disable for roles process
administrator ?
If we use command Kill in query Analyser no problem.

the option Kill appear only with roles system administrators

Why ?

Follow-Ups:
- Re: Server Roles Process administrators
  - From: jebuskrust@xxxxxxxxx

Prev by Date: Active Directory / Groups + MS SQL (yikes???)
Next by Date: Re: Server Roles Process administrators
Previous by thread: Active Directory / Groups + MS SQL (yikes???)
Next by thread: Re: Server Roles Process administrators
Index(es):
- Date
- Thread