sp-update-proxy-transact-sql.md

title	sp_update_proxy (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sp_update_proxy sp_update_proxy_TSQL
dev_langs	TSQL
helpviewer_keywords	ALTER PROXY statement sp_update_proxy
ms.assetid	864fd0e6-9d61-4f07-92ef-145318d2f881
caps.latest.revision	30
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

sp_update_proxy (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Changes the properties of an existing proxy.

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

Transact-SQL Syntax Conventions

Syntax

  
sp_update_proxy   
    [ @proxy_id = ] id,  
    [ @proxy_name = ] 'proxy_name',  
    [ @credential_name = ] 'credential_name' ,  
    [ @credential_id = ] credential_id ,  
    [ @new_name = ] 'new_name' ,  
    [ @enabled = ] is_enabled ,  
    [ @description = ] 'description'  

Arguments

[ @proxy_id= ] id
The proxy identification number of the proxy to change. The proxy_id is int, with a default of NULL.

[ @proxy_name= ] 'proxy_name'
The name of the proxy to change. The proxy_name is sysname, with a default of NULL.

[ @credential_name = ] 'credential_name'
The name of the new credential for the proxy. The credential_name is sysname, with a default of NULL. Either credential_name or credential_id may be specified.

[ @credential_id = ] credential_id
The identification number of the new credential for the proxy. The credential_id is int, with a default of NULL. Either credential_name or credential_id may be specified.

[ @new_name= ] 'new_name'
The new name of the proxy. The new_name is sysname, with a default of NULL. When provided, the procedure changes the name of the proxy to new_name. When this argument is NULL, the name of the proxy remains unchanged.

[ @enabled = ] is_enabled
Is whether the proxy is enabled. The is_enabled flag is tinyint, with a default of NULL. When is_enabled is 0, the proxy is not enabled, and cannot be used by a job step. When this argument is NULL, the status of the proxy remains unchanged.

[ @description= ] 'description'
The new description of the proxy. The description is nvarchar(512), with a default of NULL. When this argument is NULL, the description of the proxy remains unchanged.

Return Code Values

0 (success) or 1 (failure)

Remarks

Either @proxy_name or @proxy_id must be specified. If both arguments are specified, the arguments must both refer to the same proxy or the stored procedure fails.

Either @credential_name or @credential_id must be specified to change the credential for the proxy. If both arguments are specified, the arguments must refer to the same credential or the stored procedure fails.

This procedure changes the proxy, but does not change access to the proxy. To change access to a proxy, use sp_grant_login_to_proxy and sp_revoke_login_from_proxy.

Permissions

Only members of the sysadmin fixed security role can execute this procedure.

Examples

The following example sets the enabled value for the proxy Catalog application proxy to 0.

USE msdb ;  
GO  
  
EXEC dbo.sp_update_proxy  
    @proxy_name = 'Catalog application proxy',  
    @enabled = 0;  
GO  

See Also

SQL Server Agent Stored Procedures (Transact-SQL)
Implement SQL Server Agent Security
sp_add_proxy (Transact-SQL)
sp_delete_proxy (Transact-SQL)
sp_grant_login_to_proxy (Transact-SQL)
sp_revoke_login_from_proxy (Transact-SQL)