Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns one row for every SQL login.
| Column name | Data type | Description |
|---|---|---|
<inherited columns> |
-- |
Inherits from sys.server_principals. |
is_policy_checked |
bit |
Password policy is checked. |
is_expiration_checked |
bit |
Password expiration is checked. |
password_hash |
varbinary(256) |
Hash of SQL login password. |
For a list of columns that this view inherits, see sys.server_principals (Transact-SQL).
See Also
Reference
Catalog Views (Transact-SQL)
Security Catalog Views (Transact-SQL)