无语了，重启SQLAgent服务，居然SQLServer服务也重启了。 ..

Question

我修改了下SQLAgent服务的启动账号，需要重启SQLAgent服务才能使得设置生效。我重启之后，居然发现SQLServer服务也重启了。
这是为什么？
按理说不应该啊

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 1

环境 windows 2003 + SQLServer 2008 R2 标准版 +CU7

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 2

Hi Wison-Ho,

启动
　　use master
　　go
　　xp_cmdshell 'net start SQLSERVERAGENT'

　　停止
　　use master
　　go
　　xp_cmdshell 'net stop SQLSERVERAGENT'

  你可以在查询分析器用上面命令重启。

---

orichisonic http://blog.csdn.net/orichisonic If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".