dbo.sysproxies (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

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