Browse by Tags

• password
• property
• tsql

TSQL to find a login's properties such as password expiration?
23 July 07 05:22 AM | SQL Master | 1 Comments   

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

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