SELECT LOGINPROPERTY ( 'LOGIN_NAME' , 'PROPERTY_NAME' )
LOGINPROPERTY returns information about login policy settings.
Property should be one of those:
- BadPasswordCount
- BadPasswordTime
- DaysUntilExpiration
- DefaultDatabase
- DefaultLanguage
- HistoryLength
- IsExpired
- IsLocked
- IsMustChange
- LockoutTime
- PasswordHash
- PasswordLastSetTim
No comments:
Post a Comment