MSSQL - Query to list all users with type of authentication

Watch this on YouTube



Select name, type_desc
From sys.server_principals
Where type = 'U'