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

Markdown Links– Remembering the Basics

By

For some reason, I can never remember how to do markdown links. I know...

Why Aren’t You Automating Database Deployments?

By

Building out processes and mechanisms for automated code deployments and testing can be quite...

Daily Coping 23 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Query performance with ROW_NUMBER function

By vijayd

Hello All, Could any of you please let me know why the row_number paging...

multisubnet configuration

By abdalah.mehdoini

Good morning all , I am in an alwayson multisubnet configuration, the listen and...

Simple Recovery Model - Active VLFs cannot be truncated

By jdlayton83

Hi everyone, I am facing a strange situation. I've got 99% of VLFs active...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The ADF Case

See possible answers