SQL Query for Logins

Jim_1208 0
Viewed 210916

What is the SQL query to select all of the MSSQL Server's logins?

Thank you. More than one of you had the answer I was looking for:

SELECT * FROM syslogins
sql-server sql
9 Answers

Is this what you're after?

select * from master.syslogins
Brad_Wilson_15540 
EXEC sp_helplogins

You can also pass an "@LoginNamePattern" parameter to get information about a specific login:

EXEC sp_helplogins @LoginNamePattern='fred'
Matt_Hamilton_6150

@allain, @GateKiller your query selects users not logins
To select logins you can use this query: 

SELECT name FROM master..sysxlogins WHERE sid IS NOT NULL

In MSSQL2005/2008 syslogins table is used insted of sysxlogins

aku_11960

Selecting from sysusers will get you information about users on the selected database, not logins on the server.

Matt_Hamilton_6150

sp_helplogins will give you the logins along with the DBs and the rights on them.

Admin1 
Select * From Master..SysUsers Where IsSqlUser = 1
user_3830

Have a look in the syslogins or sysusers tables in the master schema. Not sure if this still still around in more recent MSSQL versions though. In MSSQL 2005 there are views called sys.syslogins and sys.sysusers.

Jason_10720
Related