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

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs

Forums

convert string + add '.'

By samirca007

Hello Please help me (how to modify a character string in sql server 2017)...

How to populate Temp table from Stored Procedure

By rkordonsky 63916

I am trying to put the result of Stored Procedure execution into Temp Table:...

Web page listing SQL code

By EamonSQL

Hi, I'm building a web page for my users that will list example SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers