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

Amit Singh

Total Post:565

Points:2825
Posted by  Amit Singh
 1407  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:565

    Points:2825
    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!