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

  • Re: Hey Frozenator
    ... kill, but they are probably a "protected" species and if you ... until I put my glasses on that is. ... and do a "bug check" before I use the bathroom. ... The windows have these heavy plastic, almost mylar coverings, like ...
    (alt.2600)
  • Re: Monster sizes (was: I dont even know why Im posting this...)
    ... VERY resistant to things that kill us quickly. ... This is true of drug doses; this is why little kids who are given, say, Motrin get a very small dose of ibuprofen -- 50mg -- while some adults may take as much as 1,000mg at once. ... that it would take much less per bug than it would for a human. ... Insect killing sprays take advantage of the fact that there are *some* poisons that kill them better than they kill us. ...
    (rec.games.frp.dnd)
  • Re: Uber Jackals?
    ... uber-jackals, and looking back on the sequence of events, there was ... There was no flaw with my character: ... It's not a bug. ... Monsters get stronger the more you kill. ...
    (rec.games.roguelike.adom)
  • Re: [BUG] signal: multithread program returns with wrong errno on receiving SIGSTOP
    ... I found a bug on signal subsystem. ... $ kill -STOP 9685 ... `./mt-wrong-errno' returns with wrong errno 512 means ERESTARTSYS. ...
    (Linux-Kernel)
  • Re: kill user connections
    ... Specifically you might want to look at sp_who and KILL ... Andrew J. Kelly SQL MVP ... > current user connections and kill these connections, ...
    (microsoft.public.sqlserver.server)