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 ...