sp_delete_proxy (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Removes the specified proxy.

|Applies to: SQL Server ( SQL Server 2008 through current version).|

Topic link icon Transact-SQL Syntax Conventions


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


[ @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



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.


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


The following example deletes the proxy Catalog application proxy.

USE msdb ;  

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

See Also

sp_add_proxy (Transact-SQL)