Export (0) Print
Expand All

dbo.sysproxies (Transact-SQL)

Defines attributes of a SQL Server Agent proxy account. This table is stored in the msdb database.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft