Applies To: SQL Server 2014, SQL Server 2016 Preview
Removes the specified proxy.
Applies to: SQL Server (SQL Server 2008 through current version).
- [ @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 ; GO EXEC dbo.sp_delete_proxy @proxy_name = N'Catalog application proxy' ; GO