dbo.sysproxies (Transact-SQL)

Applies to: SQL Server

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 at the time the proxy is added. To ensure that you have the latest information (for example, after an ALTER CREDENTIAL command), run sp_update_proxy to refresh.
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

dbo.sysproxylogin (Transact-SQL)
dbo.sysproxysubsystem (Transact-SQL)
dbo.syssubsystems (Transact-SQL)