Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008

    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.

  2. #2
    Join Date
    May 2004
    select name, has_dbaccess(name) from sysdatabases

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts