Home > DeveloperSection > Interviews > How To List All Login Names on the MS SQL Server?

Posted on    November-09-2010 12:00 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1187  View(s)
Rate this:

Amit Singh

Total Post:565

Posted on    November-09-2010 1:00 AM

Using this command to see the list of all login names on the ms sql server

SELECT name, sid, type, type_desc FROM sys.server_principals
WHERE type = 'S';

name sid type type_desc

login with sa

Don't want to miss updates? Please click the below button!

Follow MindStick