<< Death Cab for Cutie - You Are A Tourist | Guardian Green Shoots Photos >>

T-SQL to drop all non-system databases in SQL server instance

by Joe Hunter 5. May 2011 18:37

EXEC sp_MSforeachdb ' IF DB_ID(''?'') > 4 BEGIN ALTER DATABASE ? SET SINGLE_USER WITH ROLLBACK IMMEDIATE DROP DATABASE ? END'

Tags: t-sql

Related posts

How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008Reference is here Now...how to put this into a stored procedure? Getting the SQL server instance name using T-SQLHandy @@ function for getting the SQL server instance name using T-SQL: SELECT @@servernameExporting data from SQL Server to Access using a Linked ServerSo I found out the hard way that to export data from SQL Server to Microsoft Access requires that th...

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen