How to tell whether a database login is disabled without using the GUI in a select query

Question

I have been searching for an answer for the last 30 minutes on google, but haven't been able to find a satisfactory answer.

I am able to retrieve a list of db logins from the syslogins table, but it doesn't contain a field to indicate whether the login is disabled. I need to use this in a select query. Can anyone enlighten me?

Note that this applies to sql server 2000.

Answer 1

Reducing the join:

select name, is_disabled from sys.sql_logins where is_disabled=1 order by 1

Answer 2

SELECT is_disabled,*
    FROM sys.sql_logins