开发者

How to create maintenance plan in SQL Server?

When I'm trying to create a new maintenance plan in SQL Server, it is showing this error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

'Agent XPs' component is turned off 开发者_运维问答as part of the security configuration for 
this server. A system administrator can enable the use of 'Agent XPs' by using   sp_configure. 
For more information about enabling 'Agent XPs', see "Surface Area   Configuration" in 
SQL Server Books Online. (ObjectExplorer)  


You need to enable the SQL Server Agent extended stored procedures first by running the following.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜