Advertisement
uwekeim

Create prerequisites for ExpressMaint

Sep 5th, 2013
261
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.56 KB | None | 0 0
  1. /*
  2. Execute these commands e.g. inside Microsoft SQL Server Management Studio Express to configure your database so that it is prepared to run the ExpressMaint stored procedure to back up your databases.
  3.  
  4. Also see:
  5. - http://pastebin.com/GN8n87TF for enhanced ExpressMaint
  6. - http://expressmaint.codeplex.com for the ExpressMaint project
  7. */
  8.  
  9. USE [master]
  10. GO
  11.  
  12. EXEC sp_configure 'show advanced options', 1
  13. GO
  14.  
  15. RECONFIGURE;
  16. GO
  17.  
  18. EXEC sp_configure 'xp_cmdshell', 1  
  19. GO
  20.  
  21. RECONFIGURE;
  22. GO
  23.  
  24. sp_configure 'Ole Automation Procedures', 1;
  25. GO
  26.  
  27. RECONFIGURE;
  28. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement