sql server2005里面,启动sql代理服务,启动正常,但是在sql server 代理还是显示已禁用代理 xp
执行如下的sql:
sp_configure 'show advanced options', 1; go reconfigure with override; --加上with override go sp_configure 'agent xps', 1; go reconfigure with override --加上with override go
sp_configure 'show advanced options', 1; go reconfigure with override; --加上with override go sp_configure 'agent xps', 1; go reconfigure with override --加上with override go