title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
dbo.sysproxies (Transact-SQL) |
dbo.sysproxies (Transact-SQL) |
VanMSFT |
vanto |
03/14/2017 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Defines attributes of a [!INCLUDEssNoVersion] 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 at the time the proxy is added. To ensure that you have the latest information (for example, after an ALTER CREDENTIAL command), run sp_update_proxy to refresh. |
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.
dbo.sysproxylogin (Transact-SQL)
dbo.sysproxysubsystem (Transact-SQL)
dbo.syssubsystems (Transact-SQL)