title: Is there a way to query for disabled and enabled sql accounts SQL Server 2005
body: <p>Is there a way in sql server 2005 to query for enabled and disabled accounts?
  
  basically I wanted to see the current state of user accounts.
  I mean the accounts affected by command below.
  
  ALTER LOGIN someuser ENABLED|DISABLE
  </p>