Browse by Tags

All Tags » property » expiry (RSS)
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: , , , ,