HOW TO LIST ALL LOGIN NAMES ON THE MS SQL SERVER?

Amit Singh

Total Post:562

Points:2810
Posted by  Amit Singh
 1507  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:562

    Points:2810
    How To List All Login Names on the MS SQL Server?

    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';
    GO

    name sid type type_desc

    Note:
    login with sa

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!