Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

sp_helplogins doesn't show a column for this. I need a listing of all logins, with the status of their "Enforce password policy" checkbox. This is for an auditor, and the standard practice is for screenshots of every login. I'd prefer to make this simpler on me (to generate) and simpler on them to audit.

share|improve this question

Here's the start of a report:

SELECT AS LoginName,
    sl.is_policy_checked AS IsPasswordPolicyEnforced
    FROM sys.server_principals sp
    LEFT OUTER JOIN sys.sql_logins sl ON sl.principal_id = sp.principal_id
    WHERE sp.type IN ('S', 'G', 'U');

Note that this property only applies to SQL logins.

share|improve this answer

Hmph. Found it :

SELECT name, is_policy_checked FROM sys.sql_logins

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.