Runs a SQL statement against each database based on a LIKE pattern for the name of the database.
* IsLike and IsNotLike parameters let you specify both a matching pattern and an exclusion pattern for the database name.
* Script_Only mode generates the script of what the stored proc executes. Especially useful for DDL statements.
* List_Only mode generates the list of the databases affected by the IsLike/IsNotLike parameters.
* Max query string limit of 4000 characters
Be sure to read the USAGE section in the top of the stored proc.
Thanks for looking!
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.