Community

Automate your Database Maintenance using SMO

(Allen White) The most important thing you can do as a database administrator is perform regular database maintenance. This includes regular backups, database integrity checks and optimizations. In SQL Server 2000, Microsoft provided a way to create maintenance plans, which used xp_sqlmaint, to perf

Read More - Register for Free Membership