sp to drop multiple similarly named db

Procedure:    usp_drop_multiple_databases Description:    This procedure will take a string as input (it can take the % character in the calling string), put all db like that name into a list, and then drop all the databases in the resultant list.                    Example calling syntax: usp_drop_multiple_databases 'test_%_delete'--> Will drop ALL databases with a […]

2004-07-29 (first published: )

66 reads

Blogs

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Mini-Rant: Spoofed Phone Numbers and Trust

By

I’ve seen this more and more over the last year: I receive a phone...

Speaking at SQL Saturday Dallas

By

Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Import data from Word Custom Controls

By pietlinden

I'm just wondering how hard this would be in SSIS... I got it to...

insert and update

By girl_bj

Hi, need some advice. I have more than 20 columns and more than 50k...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers