List All login On All Server

SELECT * FROM sys.server_principals WHERE type IN (‘S’, ‘U’, ‘G’) ORDER BY name ASC

List All User On Server

SELECT * FROM sys.database_principals WHERE type in (‘U’, ‘G’, ‘S’)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.