Skip to content

sp-delete-proxy-transact-sql.md

Latest commit

 

History

History
80 lines (55 loc) · 1.86 KB

sp-delete-proxy-transact-sql.md

File metadata and controls

80 lines (55 loc) · 1.86 KB
title sp_delete_proxy (Transact-SQL)
description sp_delete_proxy removes the specified proxy.
author markingmyname
ms.author maghan
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sp_delete_proxy
sp_delete_proxy_TSQL
helpviewer_keywords
sp_delete_proxy
DROP PROXY statement
dev_langs
TSQL

sp_delete_proxy (Transact-SQL)

[!INCLUDE SQL Server]

Removes the specified proxy.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_delete_proxy
    [ [ @proxy_id = ] proxy_id ]
    [ , [ @proxy_name = ] N'proxy_name' ]
[ ; ]

Arguments

[ @proxy_id = ] proxy_id

The proxy identification number of the proxy to remove. @proxy_id is int, with a default of NULL.

[ @proxy_name = ] N'proxy_name'

The name of the proxy to remove. @proxy_name is sysname, with a default of NULL.

Return code values

0 (success) or 1 (failure).

Result set

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 can't 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

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

Related content