How To List All Login Names on the MS SQL Server? Amit Singh244709-Nov-2010mssql servermssql server Updated on 20-Sep-2020
Amit Singh
09-Nov-2010SELECT name, sid, type, type_desc FROM sys.server_principals
WHERE type = 'S';
GO
name sid type type_desc
Note: login with sa