-- ------------
Use the Manipulate Service Principal Names for Accounts (SetSPN.exe) utility
loginproperty
DECLARE @my_login_name char(20);
SET @my_login_name = 'sa';
SELECT 'IsLocked' AS Property, LOGINPROPERTY(@my_login_name, 'IsLocked') AS Value
union all
SELECT 'IsExpired' AS Property, LOGINPROPERTY(@my_login_name, 'IsExpired') AS Value
union all
SELECT 'DaysUntilExpiration' AS Property, LOGINPROPERTY(@my_login_name, 'DaysUntilExpiration') AS Value
union all
SELECT 'IsMustChange' AS Property, LOGINPROPERTY(@my_login_name, 'IsMustChange') AS Value
union all
SELECT 'BadPasswordCount' AS Property, LOGINPROPERTY(@my_login_name, 'BadPasswordCount') AS Value
union all
SELECT 'PasswordLastSetTime' AS Property, LOGINPROPERTY(@my_login_name, 'PasswordLastSetTime') AS Value
union all
SELECT 'BadPasswordTime' AS Property, LOGINPROPERTY(@my_login_name, 'BadPasswordTime') AS Value
union all
SELECT 'LockoutTime' AS Property, LOGINPROPERTY(@my_login_name, 'LockoutTime') AS Value
union all
SELECT 'PasswordHash' AS Property, LOGINPROPERTY(@my_login_name, 'PasswordHash') AS Value
union all
SELECT 'PasswordHashAlgorithm' AS Property, LOGINPROPERTY(@my_login_name, 'PasswordHashAlgorithm') AS Value;
GO
|
SELECT 'IsLocked' AS Property, LOGINPROPERTY('sa', 'IsLocked') AS Value
union all
SELECT 'IsExpired' AS Property, LOGINPROPERTY('sa', 'IsExpired') AS Value
union all
SELECT 'DaysUntilExpiration' AS Property, LOGINPROPERTY('sa', 'DaysUntilExpiration') AS Value
union all
SELECT 'IsMustChange' AS Property, LOGINPROPERTY('sa', 'IsMustChange') AS Value
union all
SELECT 'BadPasswordCount' AS Property, LOGINPROPERTY('sa', 'BadPasswordCount') AS Value
union all
SELECT 'PasswordLastSetTime' AS Property, LOGINPROPERTY('sa', 'PasswordLastSetTime') AS Value
union all
SELECT 'BadPasswordTime' AS Property, LOGINPROPERTY('sa', 'BadPasswordTime') AS Value
union all
SELECT 'LockoutTime' AS Property, LOGINPROPERTY('sa', 'LockoutTime') AS Value
union all
SELECT 'PasswordHash' AS Property, LOGINPROPERTY('sa', 'PasswordHash') AS Value
union all
SELECT 'PasswordHashAlgorithm' AS Property, LOGINPROPERTY('sa', 'PasswordHashAlgorithm') AS Value;
GO
|