Popular Posts

  • Error: 18056, Severity: 20, State: 23
    SQLServerCentral » Latest topics Error: 18056, Severity: 20, State: 23 Hi.. Error: 18056, Severity: 20, State: 23. Message The clie...
  • sp_helpindex2
    SQLblog.com - The SQL Server blog spot on the web sp_helpindex2 --my extension of sp_helpindex: sp_helpindex2 USE master GO IF EXIS...
  • SSMS for Linux
    SQLServerCentral » Latest topics SSMS for Linux I can't find information on the Web about whether Microsoft plans to develop an...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Wednesday, August 30, 2017

List all logins, databases, role mapping

SQLServerCentral » Latest topics
List all logins, databases, role mapping
Hi there, I'm looking for a query or script that can generate a list of all SQL Server login's on an instance, along with all the roles they are mapped to on what databases. I'm new to SQL Server and am unaware of what system views or tables I can use to
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)