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.
Applies to: 
SQL Server
Shows which SQL Server logins are associated with each SQL Server Agent proxy account. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| proxy_id | int | ID of the SQL Server Agent proxy account. This value corresponds to the proxy_id column in the sysproxies table. |
| sid | varbinary(85) | Microsoft Windows security_identifier for the SQL Server login. |
| flags | int | Type of login:0 = Windows user or group, and SQL Server login. 1 = SQL Server fixed system role 2 = msdb database role |
Remarks
Only members of the sysadmin fixed server role can access this table.