¿COMO COMPRUEBO SI EXISTE UNA BASE DE DATOS? SQL SERVER

use irrigacion

go

drop procedure CompruebaBD

go

create procedure CompruebaBD

@dbname VARCHAR(128)

as

begin

begin try

IF (not EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = @dbname OR name = @dbname)))

-- code mine :)

exec ('create database '+@dbname)

select 'FALSE' AS ERRORES, 'SIN ERRORES' AS DESCRIPCION,@@ROWCOUNT AS AFECTADAS,'CREADA' as CREADA

end try

begin catch

SELECT 'TRUE' AS ERRORES, ERROR_MESSAGE() AS DESCRIPCION,@@ROWCOUNT AS AFECTADAS,'NO CREADA' AS CREADA

end catch

end