Removes the specified proxy.
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.
0 (success) or 1 (failure)
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 ;
@proxy_name = N'Catalog application proxy' ;