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

Published 23 July 07 05:22 AM | SQL Master 

declare @name nchar(100)

SET @name ='<LoginName'

SELECT LOGINPROPERTY( @name, 'PasswordLastSetTime' ) AS PasswordLastSetTime, LOGINPROPERTY( @name, 'IsExpired' ) AS IsExpiried, LOGINPROPERTY( @name, 'IsLocked' ) AS IsLocked, LOGINPROPERTY( @name, 'IsMustChange' ) AS IsMustChange, LOGINPROPERTY( @name, 'LockoutTime' ) AS LockoutTime, LOGINPROPERTY( @name, 'BadPasswordCount' ) AS BadPasswordCount, LOGINPROPERTY( @name, 'BadPasswordTime' ) AS BadPasswordTime, LOGINPROPERTY( @name, 'HistoryLength' ) AS HistoryLength, LOGINPROPERTY( @name, 'PasswordHash' ) AS PasswordHash, LOGINPROPERTY( @name, 'PasswordLastSetTime' ) AS PasswordLastSet

GO

Filed under: , , , ,

Comments

# SSQA.net - SqlServer-QA.net said on July 23, 2007 6:16 PM:

declare @name nchar ( 100 ) SET @name = &#39;&lt;LoginName&#39; SELECT LOGINPROPERTY ( @name , &#39;PasswordLastSetTime&#39;

Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.