Re: Server Roles Process administrators

I don't know what to tell you then. You can give MS PSS a call and if it is
a bug they will refund the cost of the call. But that doesn't mean there is
a fix for it or that there ever will be since 2005 is the preferred version
now. Why is this such an issue? Why are you killing a lot of spids? This
isn't something that should be done all the time and I would hope it is a
sysadmin that is making the decision to do it.

http://www.support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL
Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS

--
Andrew J. Kelly SQL MVP


"Patrick" <Patrick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1C1BD083-11AA-4128-90B2-F3AA84DF2528@xxxxxxxxxxxxxxxx
Yes am sure the entreprise manager is registered under the account that I
gave
Processadmin right
I think is a bug in the tools but I need a confirmation
maybe Microsoft have hotfix or patch to msdb ?

I do the test we NT account or SQL account same problem.

could you try and confirm me

"Andrew J. Kelly" wrote:

Are you sure that Enterprise Manager is registered under the account that
you gave the ProcessAdmin rights to? Did you close and reopen it
afterwards? It may be a bug with the tools but I would check the
regististration first.

--
Andrew J. Kelly SQL MVP


"Patrick" <Patrick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4670227C-5C9D-4B39-844F-BE12C74A2564@xxxxxxxxxxxxxxxx
Server SQL 2000 SP4
In SQL manager the Kill Process option stay disable for the roles
process
administrator ?
If we use command Kill in query Analyser no problem.
the option Kill appear only with roles system administrators
I put the user processadmin and the kill option still disable
I try It on four Server same problem.

How to Kill Process with only process admin right ?
Thank







.

Relevant Pages