Home Forums SQL Server 2005 SQL Server 2005 General Discussion How do i Set Password Expiration days for a SQL Login RE: How do i Set Password Expiration days for a SQL Login
ChiragNS
One Orange Chip
Points: 26137
More actions
December 21, 2007 at 4:45 am
#762043
Hi
If you are creating logins from SSMS you check the checkbox which says "Enforce password policy".
If you are using a script use the CHECK_EXPIRATION option of the "Create login" statement.
"Keep Trying"