How to determine if database login is disabled without using a graphical interface in the selected query

Question

I searched for an answer in the last 30 minutes on Google, but could not find a satisfactory answer.

I can get a list of db logins from the syslogins table, but it does not contain a field indicating whether the input is disabled. I need to use this in the selected query. Can anyone enlighten me?

Note that this applies to SQL Server 2000.

Answer 1

select name, hasaccess from sys.syslogins 

I believe the hasaccess field is what you are looking for. According to MSDN , hasaccess is 1 if the login has access to the instance, and 0 if not.

Answer 2

Connection Reduction:

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

Answer 3

use sys.sql_logins to check on / off login status. Example

 select * from syslogins sl join sys.sql_logins sql on sl.sid=sql.sid where is_disabled=1 

Answer 4

 SELECT is_disabled,* FROM sys.sql_logins 

Answer 5

The accepted answer is incorrect because it does not provide useful information. If the account is disabled, the hasaccess column can still be 1 .

Closest correct:

 select name,is_disabled,* from sys.sql_logins where name = '' , if its an SQL account.