List all disabled SQL Server logins

To list all disabled SQL Server logins, run the following query:

SELECT name, is_disabled
FROM sys.sql_logins
WHERE is_disabled = 1;

list all disabled logins in SQL Server