sysproxies (Transact-SQL)
Defines attributes of a SQL Server Agent proxy account. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
proxy_id |
int |
ID of the proxy account. |
name |
sysname |
Name of the proxy account. |
credential_id |
int |
ID of the credential that the proxy account uses. |
enabled |
tinyint |
Status of the proxy account: 0 = Disabled. 1 = Enabled. |
description |
nvarchar(512) |
Description that the user entered when the proxy account was created. |
user_sid |
varbinary(85) |
Microsoft Windows security_identifier of the user or group associated with the proxy credential. |
credential_date_created |
datetime |
Date and time that the credential was created. |
Remarks
Only members of the sysadmin fixed server role can access the sysproxies table.
See Also
Reference
sysproxylogin (Transact-SQL)
sysproxysubsystem (Transact-SQL)
syssubsystems (Transact-SQL)