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

2004-07-29 (first published: )

68 reads

Blogs

Daily Coping 18 Oct 2021

By

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

Azure Cosmos DB – HTAP using Azure Synapse Link

By

I haven’t done much blogging in the last 6 months. My last article was...

Azure Cosmos DB – HTAP using Synapse Analytics

By

I haven’t done much blogging in the last 6 months. My last article was...

Read the latest Blogs

Forums

Event log filling up with Sql error

By IT researcher

Windows event log filling up with ERROR 1 : "The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-]' running...

How to do Join

By patla4u

Hello, I am looking for output where EG_RequestID = 175998968 and Reissue from paymentID...

Connect to PostgreSQL as an External Data Source using PolyBase

By JerodJ

Comments posted to this topic are about the item Connect to PostgreSQL as an...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers