var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problems with sp_MShasdbaccess
I am currently working with a system that connects to the master system and executes sp_MShasdbaccess to confirm capability to log into one of the other databases within the service.
However, sometimes the database will not be returned in the result set and sometimes they will. Can't figure out why.
Therefore sometimes the user can log in and other times they may not be able to.
select name, has_dbaccess(name) from sysdatabases