LOGINPROPERTY (information about login policy settings)
LOGINPROPERTY function returns information about the password policy settings of a SQL Server login.
The names of the properties are not case sensitive.
NULL will be returnd if the login is not a valid SQL Server login.
declare @loginname nvarchar(200)
set @loginname = 'tosica'
SELECT
LOGINPROPERTY( @loginname, 'IsLocked' ) AS IsLocked,
LOGINPROPERTY( @loginname, 'IsExpired' ) AS IsExpiried,
LOGINPROPERTY( @loginname, 'IsMustChange' ) AS IsMustChange,
LOGINPROPERTY( @loginname, 'BadPasswordCount' ) AS BadPasswordCount,
LOGINPROPERTY( @loginname, 'BadPasswordTime' ) AS BadPasswordTime,
LOGINPROPERTY( @loginname, 'HistoryLength' ) AS HistoryLength,
LOGINPROPERTY( @loginname, 'LockoutTime' ) AS LockoutTime,
LOGINPROPERTY( @loginname, 'PasswordLastSetTime' ) AS PasswordLastSet,
LOGINPROPERTY( @loginname, 'PasswordHash' ) AS PasswordHash