<p>What is the SQL query to select all of the MSSQL Server's logins?</p>

<p>Thank you.  More than one of you had the answer I was looking for:</p>

<pre><code>SELECT * FROM syslogins 
</code></pre>

```
```
EXEC sp_helplogins
```
```
You can also pass an "@LoginNamePattern" parameter to get information about a specific login:
```
```
EXEC sp_helplogins @LoginNamePattern='fred'
```
```