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.

Search

Go

This Blog

«July 2007»
SMTWTFS
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234

Syndication