SQL Server – Check if “Enforce Password Policy” is On Using TSQL

  By , ,

The T-SQL query below will check if “Enforce Password Policy” is On. A value of 1 under is_policy_checked column indicates that it is turned on. Otherwise, it is disabled.

select name, is_policy_checked 
from sys.sql_logins
Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter

Related posts:

  1. SQL Server – VIEW SERVER STATE
  2. SQL Server – Find Owners of SQL Server Agent Jobs Using TSQL
  3. SQL Server – View FileNames and Paths Using TSQL
  4. SQL SERVER – TSQL Script to Change the Compatibility Level of all Databases
Tagged  , , , , , , , , , , .
Bookmark the permalink.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *