USE [master] GOIF EXISTS (SELECT name FROM sys.databases WHERE name = N'YourDatabaseName')
DECLARE @dbname nvarchar(128) SET @dbname = N'aa'IF (EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = @dbname OR name = @dbname)))-- code mine :) PRINT 'db exists'
GOIF EXISTS (SELECT name FROM sys.databases WHERE name = N'YourDatabaseName')
SET @dbname = N'aa'IF (EXISTS (SELECT name
FROM master.dbo.sysdatabases
WHERE ('[' + name + ']' = @dbname
OR name = @dbname)))-- code mine :)
PRINT 'db exists'