Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

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.

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.