List of all logins in SQL Server those are enabled/disabled

• salman788

  Mr or Mrs. 500

  Points: 583

  More actions

  August 19, 2011 at 2:46 pm

  #242494

  How to find out List of all logins in SQL Server those are enabled/disabled.

• eccentricDBA

  SSCarpal Tunnel

  Points: 4844

  More actions

  August 19, 2011 at 2:54 pm

  #1370983

  SELECT name, type_desc, is_disabled

  FROM sys.server_principals

  http://msdn.microsoft.com/en-us/library/ms188786.aspx