Click here to monitor SSC
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: 377 | Views in the last 30 days: 3
 
Related Articles
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 ...

BLOG

SQL lunch #28-SSIS Design Patterns 1a: Introduction to SSIS Design Patterns

In this three part series SQL Server MVP Andy Leonard will discuss SSIS Design Patterns. Speak...

FORUM

T-SQL 2005 String Pattern??

T-SQL 2005 String Pattern??

 
Contribute