Database maintenance - sample plans to reindex and update statistics (using script)

The attached scripts are provided as a sample means of implementing regular database maintenance.  Please note that the scripts are provided as-is basis.

Execute the attached DDL.sql into the master database.  This can be done at any time as it is just creating the maintenance objects.

Execute the Execute.sql in the master database.  You will need to change the @Databases = 'Insol2' to the name of your insolvency database if it is something different to Insol2 (note that this parameter is specified twice in the script). 

The Execute.sql script should be scheduled to run on a regular basis via SQL agent.  Once weekly should be sufficient.