Posted by coosa on 05/28/06 14:31

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

• Next in forum: Re: SQL Server 2005: CLR functions vs SQL functions
• Prev in forum: Re: Insert a record in a particular place
• Thread view: Re: T-SQL CLOSE Connection to DB

[Reply to this message]