sysproxies (Transact-SQL)

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.