Transact-SQL Reference
HAS_DBACCESS
Returns information about whether the user has access to the specified database.
Syntax
HAS_DBACCESS ( 'database_name' )
Arguments
database_name
Is the name of the database for which the user wants access information. database_name is sysname.
Return Types
int
Remarks
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.