SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)


By zendance,

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!

Total article views: 379 | Views in the last 30 days: 1
Related Articles

SQL Server Performance Benchmarking with Patterns

A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.


Free Webcast Series: Patterns and Practices in Database Administration

SSWUG.ORG’s virtual webcasts will prepare the “Accidental DBA” for patterns and practices they wil...


Incremental pattern matching

Incremental pattern matching in column.


Generating a Sequential Pattern

For many of us, working with the identity property allows us to easily generate a sequential series ...


Pattern Recognition via Principal Components Analysis

We'll look at using principal components analysis to help visualise your data and detect underlying ...