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.|
Only members of the sysadmin fixed server role can access the sysproxies table.