Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Lists the name and owner of all the databases to which the user has access.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
sp_MShasdbaccess
Return Code Values
0 (success) or 1 (failure)
Permissions
Execute permission is granted to the public role.
See Also
Reference
sys.sysdatabases (Transact-SQL)