sp_delete_proxy (Transact-SQL)
Removes the specified proxy.
.gif "Topic link icon")
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