Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Jim Youmans,
This stored procedure will find all the SQL Logins on a server and tell you the age of the logins password and it will also check for blank passwords and passwords that are the same as the login name. If you create a common password table, it will also check the logins passwords against those in your table. The common password table format is:
CREATE TABLE [dbo].[CommonPwds](
[pwd] [varchar](25) NULL
) ON [PRIMARY]
This script lists all of the SQL logins with their password policy
Reset Password for linked server login
Moving user logins and passwords
Audit your SQL logins to find passwords that have never been changed or that are very weak.
How do users change passwords at next login when they are sql server logins?