sp-delete-proxy-transact-sql.md

title	sp_delete_proxy (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.service
ms.component	system-stored-procedures
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sp_delete_proxy sp_delete_proxy_TSQL
dev_langs	TSQL
helpviewer_keywords	sp_delete_proxy DROP PROXY statement
ms.assetid	44a1db13-b7f2-4dab-a1b5-b8dafb41737c
caps.latest.revision	21
author	stevestein
ms.author	sstein
manager	craigg
ms.workload	Inactive

sp_delete_proxy (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Removes the specified proxy.

Transact-SQL Syntax Conventions

Syntax

  
sp_delete_proxy [ @proxy_id = ] id , [ @proxy_name = ] 'proxy_name'  

Arguments

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

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

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

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.

If a job step refers to the proxy specified, the proxy cannot be deleted and the stored procedure fails.

Permissions

By default, only members of the sysadmin fixed server role can execute sp_delete_proxy.

Examples

The following example deletes the proxy Catalog application proxy.

USE msdb ;  
GO  
  
EXEC dbo.sp_delete_proxy  
    @proxy_name = N'Catalog application proxy' ;  
GO  

See Also

sp_add_proxy (Transact-SQL)