Is there a way to query for disabled and enabled sql accounts SQL Server 2005

Is there a way in sql server 2005 to query for enabled and disabled accounts? basically I wanted to see the current state of开发者_如何学C user accounts. I mean the accounts affected by command below. ALTER LOGIN someuser ENABLED|DISABLE

select * from sys.sql_logins gives you the information you're after. Take a look @ the is_disabled column.

You're "not supposed" to query the sys tables directly. sp_helpuser, sp_MShasdbaccess can be used as an alternative.