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;