Browse by Tags

TSQL to find a login's properties such as password expiration?

Published 23 July 7 7:22 AM | SSQA.net

declare @name nchar ( 100 ) SET @name = '<LoginName' SELECT LOGINPROPERTY ( @name , 'PasswordLastSetTime' ) AS PasswordLastSetTime , LOGINPROPERTY ( @name , 'IsExpired' ) AS IsExpiried , LOGINPROPERTY ( @name , 'IsLocked'...

Filed under: login, password, tsql, expiry, property

Alert particular set of users about PASSWORDY EXPIRY policy notification

Published 23 July 7 3:33 AM | SSQA.net

As you may be aware using SQL 2005 version you can set PASSWORD EXPIRY policy that can apply the same complexity and expiration policies used in Windows Server 2003 operating system to passwords used inside SQL Server. This functionality depends on the...

Filed under: sql server, management, security, mail, login, alerts, password, dbmail, expiry