Reporting Compliance with Password Policy

• JunkMail Victim

  Old Hand

  Points: 392

  More actions

  July 6, 2007 at 12:33 pm

  #196837

  Does anyone know of a stored procedure or view that will tell if a SQL Server 2005 account was created with the underlying password policy enforced, and a password expiration?

  This is for compliance purposes, and I want to find something that's simpler than taking screenshots of all of the login properties.

  Thanks.

• JunkMail Victim

  Old Hand

  Points: 392

  More actions

  July 8, 2007 at 1:28 pm

  #717882

  I found my own answer:

  SELECT * FROM sys.sql_logins

  Thanks.