quote:

---

start
stop
pause
continue
querystate (Almost forgot that one as noted in previous posters post).

Parameter 2 is the Service Name.

For example "FTP Publishing Service" is MSFTPSVC.

---

thank you both!

Any secret fountain of wisdom, Antares, you might want to share?

Now, the more interesting one.
I execute this with sa permission.
Am I able to start, stop.. services on that machine, although I am not NT admin to this box?

Of course, this is only for security reasons

Cheers,
Frank

Server: Msg 22003, Level 16, State 1, Line 0
StartService() returned error 997, 'Overlapped I/O operation is in progress.'

quote:

---

No secret there. I just ran it on my testbox here to see what happens when. The only thing that is confusing is that it gives the following error

---

lucky one!
My testbox is SQL7. I was told for some good reasons, I can't remember right now!

quote:

---

In addition I seem to recall a few years ago something about SQL having this setup with Public having execute rights but a later patch changed. You might want to check just in case and remove that right. DOes anyone else recall the details on this?

---

I have seen something on http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4 . Also, when you google on this topic, you will find some very interesting ppt's from M$. Unfortunately in some asian language

Cheers,
Frank

quote:

---

If MSSQLSERVER is running under an admin account you certainly can.

Reminds me of the time I used it (for security purposes) to stop sqlserveragent, start sqlserveragent, stop dhcp, start dhcp, stop mssqlserver..... oops

---

quote:

---

If MSSQLSERVER is running under an admin account you certainly can.

Reminds me of the time I used it (for security purposes) to stop sqlserveragent, start sqlserveragent, stop dhcp, start dhcp, stop mssqlserver..... oops


Cheers,
- Mark

---

Yeah, I have to try one running under Local System Account but I gotta run so don't have time to test.

And don't feel bad. We use NetOp, PCDuo and Terminal Services and I'll be darned if when working with a few boxes I needed to disable the NIC and Reenable for testing. But for some reason disable stops everything from working for me.