dbo.sysproxylogin (Transact-SQL)

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


Only members of the sysadmin fixed server role can access this table.

dbo.sysproxies (Transact-SQL)