Sample Header Ad - 728x90

How to display User Mapping for offline databases?

0 votes
2 answers
3174 views
When I use the GUI (SSMS) to review the User Mapping, where the Login has mapping to a database that is offline (*or otherwise not available*) I get the message below and it only displays Mapping for databases that are online. > One or more databases are inaccessible and will not be displayed in list All the details should actually be in the Master DB, there should be something I can run that will show me what the full User Mapping is. How can I display User Mapping for offline databases?
Asked by James Jenkins (6318 rep)
Jun 1, 2016, 03:11 PM
Last activity: Oct 11, 2018, 05:44 PM