View Login Details on MS SQL database

Some of the useful SQL syntax

Viewing logins and Databases:

SELECT * FROM sys.sql_logins;

SELECT * FROM sys.databases;
SP_helpuser:

Reports information about database-level principals in the current database.

Syntax: sp_helpuser

Naveen Mukkasa - MCTS