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)

DBA_EverywhereRun

By zendance,

Runs a SQL statement against each database based on a LIKE pattern for the name of the database.

Features:
* 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.

Limitations:
* Max query string limit of 4000 characters

Be sure to read the USAGE section in the top of the stored proc.

Thanks for looking!
Mike

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

SQL Server Performance Benchmarking with Patterns

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

BLOG

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...

FORUM

Incremental pattern matching

Incremental pattern matching in column.

ARTICLE

Generating a Sequential Pattern

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

ARTICLE

Pattern Recognition via Principal Components Analysis

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

 
Contribute