View Single Post

   
  #3 (permalink)  
Old 02-29-2008, 07:30 PM
coosa
 
Posts: n/a
Default Re: T-SQL CLOSE Connection to DB

I did actually,

USE [Master];
GO

IF EXISTS (SELECT name FROM sys.databases WHERE name = N'MyDB')
BEGIN
PRINT N'Database [MyDB] already exists';
DROP DATABASE MyDB;
END
GO

Reply With Quote