sp_delete_proxy (Transact-SQL)

Removes the specified proxy.

Topic link iconTransact-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.

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 ;

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