List Server Principals (Logins/Users) – SQL Server

use[master]
-- SQL Server authentication logins
select * from sys.sql_logins
-- all logins/users
select * from sys.server_principals order by type_desc