Monday, May 31, 2010

[MSSQL] Enabling Agent XPs 

To enable the Maintenance Plans in MSSQL 2005

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)