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
How do users change passwords at next login when they are sql server logins?
This store procedure will send a proactively mail about the SQL login name & there expiry date for w...