Skip to content

replace-xp-sqlagent-proxy-account-extended-sp-with-new-stored-procedures.md

Latest commit

 

History

History
50 lines (34 loc) · 2.25 KB

replace-xp-sqlagent-proxy-account-extended-sp-with-new-stored-procedures.md

File metadata and controls

50 lines (34 loc) · 2.25 KB
title Replace usage of the xp_sqlagent_proxy_account extended stored procedure with new stored procedures | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology database-engine
ms.topic conceptual
helpviewer_keywords
xp_sqlagent_proxy_account
ms.assetid 0e3cc931-6237-41dd-bf0d-0c03f4d8fff2
author mashamsft
ms.author mathoma
manager craigg

Replace usage of the xp_sqlagent_proxy_account extended stored procedure with new stored procedures

[!INCLUDEssNoVersion] Agent supports multiple proxies. You define these proxies by using a new set of stored procedures. For more information about the new [!INCLUDEssNoVersion] Agent stored procedures, see the following topics in [!INCLUDEssNoVersion] Books Online:

  • "sp_add_proxy ([!INCLUDEtsql])"

  • "sp_delete_proxy ([!INCLUDEtsql])"

  • "sp_enum_login_for_proxy ([!INCLUDEtsql])"

  • "sp_enum_proxy_for_subsystem ([!INCLUDEtsql])"

  • "sp_enum_sqlagent_subsystems ([!INCLUDEtsql])"

  • "sp_grant_proxy_to_subsystem ([!INCLUDEtsql])"

  • "sp_grant_login_to_proxy ([!INCLUDEtsql])"

  • "sp_help_proxy" ([!INCLUDEtsql])"

  • "sp_revoke_login_from_proxy ([!INCLUDEtsql])"

  • "sp_revoke_proxy_from_subsystem ([!INCLUDEtsql])"

  • "sp_update_proxy ([!INCLUDEtsql])"

Note

After you upgrade to [!INCLUDEssKatmai], any statements that use the xp_sqlagent_proxy_account extended stored procedure will not work. Use sp_xp_cmdshell_proxy_account instead of xp_sqlagent_proxy_account to set the proxy for xp_cmdshell.

Component

[!INCLUDEssNoVersion] Agent

See Also

SQL Server Agent Upgrade Issues