TechNet
Export (0) Print
Expand All

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 nameData typeDescription
proxy_idintID of the proxy account.
namesysnameName of the proxy account.
credential_idintID of the credential that the proxy account uses.
enabledtinyintStatus of the proxy account:

 0 = Disabled. 1 = Enabled.
descriptionnvarchar(512)Description that the user entered when the proxy account was created.
user_sidvarbinary(85)Microsoft Windows security_identifier of the user or group associated with the proxy credential.
credential_date_createddatetimeDate and time that the credential was created.

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

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

Community Additions

ADD
Show:
© 2016 Microsoft