Technical Article

Drop all Databases (+the option to exclude one)

I made this Query because we fix databases localy on a workstation (we have no sql server) but when backup up the server they need to be deleted localy that could sometimes take a while.U can run this Query from the QA or ad it as a Job it's possible to run it from an […]

4.5 (2)

You rated this post out of 5. Change rating

2005-08-26 (first published: )

502 reads

Blogs

A Study in SQL Server Ad hoc Query Plans

By

A Study in SQL Server Ad hoc Query Plans ...

Friday Flyway Tips–Flyway Parameters

By

Flyway is a command line tool with lots of options and parameters. Working with...

Read the latest Blogs

Forums

table with varcahar(max)

By sqlguy80

Gurus, there is a table which is very slow to query , it has...

Query goes crazy.

By Robert-378556

Hi. I have a query that returns few rows (out of 7 table join,...

Migration from Sybase SAP SQL Anywhere to SQL Server 2022

By Stewart "Arturius" Campbell

We are working on a project to migrate a client from a version of...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers