The non-SSIS/GUI method I use to deploy standardized Database Maintenance Plans.
2013-05-16 (first published: 2009-05-07)
Compare SQL code of sp, functions, or triggers. Can run across DB and/or servers. Generates report similar to windif. See details in comments
2008-10-31 (first published: 2008-09-05)
Database tables without primary key, clustered index and no index
2008-08-13 (first published: 2008-06-17)
Script to move physical files to a new location
2012-03-30 (first published: 2008-04-21)
Index maintenance procedure using rebuild or reorganized based on fragementation level.
2011-10-26 (first published: 2008-03-28)
How to set the database to a single user mode
2012-07-13 (first published: 2008-03-20)
As per Threshold value DBA will get notified about the Disk Drive usage.
2007-11-23 (first published: 2007-10-08)