Home Forums SQL Server 2014 Administration - SQL Server 2014 Find all the inactive Windows Logins RE: Find all the inactive Windows Logins
Manoj Bhopale
SSC Rookie
Points: 47
More actions
January 31, 2014 at 4:17 am
#1684982
Use this query to find out disabled windows users/groups.
SELECT name from sys.server_principals
where is_disabled='1' and type_desc like '%WINDOWS%'