Technical Article

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 […]

You rated this post out of 5. Change rating

2004-07-29 (first published: )

68 reads

Blogs

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server

By

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

Read the latest Blogs

Forums

Be Careful with Missing Index Requests

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Be Careful with Missing Index...

GitHub Copilot - Our Best Ally to for T-SQL

By Daniel Calbimonte

Comments posted to this topic are about the item GitHub Copilot - Our Best...

Zero Statistics Sampling

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Zero Statistics Sampling

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers