udf_is_database_available

if object_id('udf_is_database_available') is not null
    drop function udf_is_database_available
go

create function udf_is_database_available(@Databasename sysname)
/*
    Criteria:    - database must exist
                - multi-user access
                - not read-only
                - status ONLINE

    v20081105    "select count()" instead of "if exists"
*/returns bit as
begin
    return    (
                    select    count(*) 
                    from    master.sys.databases
                    where    name = @databasename
                    and        user_access = 0
                    and        is_read_only = 0
                    and        state = 0
                )
end
go