sys.credentials (Transact-SQL)
SQL Server 2005
Returns one row for each credential.
| Column name | Data type | Description |
|---|---|---|
|
credential_id |
int |
ID of the credential. Is unique within the server |
|
name |
sysname |
Name of the credential. Is unique within the server |
|
credential_identity |
nvarchar(4000) |
Name of the identity to be used. This will generally be a Windows user. It need not be unique. |
|
create_date |
datetime |
Time at which the credential was created |
|
modify_date |
datetime |
Time at which the credential was last modified |
Reference
Security Catalog Views (Transact-SQL)Catalog Views (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)
Other Resources
CredentialsPrincipals
