This is a script you can run on a per-server basis, from any database in Query Analyzer or incorporate into a stored procedure, that will examine all databases on that instance of SQL and show what Maintenance Plan(s) they are part of, if any. Shows clearly any databases that are not currently part of a Plan. Very useful for auditing your servers periodically to make sure you are not missing any databases. Verified to work for both SQL 7 and SQL 2000.
Notes: If you use the All system databases or All user databases options in your Maintenance Plans, individual dbs will not be listed as linked to those plans.
This script is very helpful for anyone trying to recreate particular SQL Server Database Versions for Testing. It allows you to automatically recompile any stored procedures or views saved with drop, create and permission statements. The scripts must all be sitting in one directory and end in the same extension. I have found this very […]