Skip to content

Latest commit

 

History

History
37 lines (31 loc) · 1.4 KB

dbo-sysproxysubsystem-transact-sql.md

File metadata and controls

37 lines (31 loc) · 1.4 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
dbo.sysproxysubsystem (Transact-SQL)
dbo.sysproxysubsystem (Transact-SQL)
VanMSFT
vanto
03/14/2017
sql
system-objects
reference
dbo.sysproxysubsystem_TSQL
dbo.sysproxysubsystem
sysproxysubsystem_TSQL
sysproxysubsystem
sysproxysubsystem system table
TSQL

dbo.sysproxysubsystem (Transact-SQL)

[!INCLUDE SQL Server]

Records which [!INCLUDEssNoVersion] Agent subsystem is used by each proxy account. This table is stored in the msdb database.

Column name Data type Description
subsystem_id int ID of the subsystem. This value corresponds to the subsystem_id column in the syssubsystems table.
proxy_id int ID of the proxy account. This value corresponds to the proxy_id column in the sysproxies table.

Remarks

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

See Also

dbo.syssubsystems (Transact-SQL)
dbo.sysproxies (Transact-SQL)