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: )

68 reads

Blogs

Getting Up and Running with Dapr

By

I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...

Data Platform products for Microsoft gaps

By

Microsoft has a ton of data platform-related products, but there are certain areas where...

Accessibility in font choice

By

Choosing the right typeface for your presentation (or for that matter anything you create...

Read the latest Blogs

Forums

Import Multiple Packages to SSIS server

By sagarSQLDBA

Comments posted to this topic are about the item Import Multiple Packages to SSIS...

need help on query

By abhas

Hi all, need help on below requirement. Thanks, Abhas

Problem with SUM and GROUP BY clause connection

By JeremyU

Hello friends, I will appreciate if someone can help me to sum and later...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers