Returns information about whether the user has access to the specified database.
HAS_DBACCESS ( 'database_name' )
Is the name of the database for which the user wants access information. database_name is sysname.
HAS_DBACCESS returns 1 if the user has access to the database, 0 if the user has no access to the database, and NULL if the database name is invalid.