Skip to content

sp-delete-firewall-rule-azure-sql-database.md

Latest commit

 

History

History
72 lines (57 loc) · 3.04 KB

sp-delete-firewall-rule-azure-sql-database.md

File metadata and controls

72 lines (57 loc) · 3.04 KB

title: "sp_delete_firewall_rule (Azure SQL Database) | Microsoft Docs" ms.custom: "" ms.date: "07/27/2016" ms.prod: "" ms.prod_service: "sql-database, sql-data-warehouse" ms.reviewer: "" ms.service: "sql-database" ms.component: "system-stored-procedures" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
  • "sp_delete_firewall_rule_TSQL"
  • "sp_delete_firewall_rule"
  • "sys.sp_delete_firewall_rule"
  • "sys.sp_delete_firewall_rule_TSQL" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "sp_delete_firewall_rule procedure" ms.assetid: cf93eed1-ba97-4850-9fcc-b9c5a9317908 caps.latest.revision: 14 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || = azure-sqldw-latest || = sqlallproducts-allversions"

sp_delete_firewall_rule (Azure SQL Database)

[!INCLUDEtsql-appliesto-xxxxxx-asdb-asdw-xxx-md]

Removes server-level firewall settings from your [!INCLUDEssSDS] server. This stored procedure is only available in the master database to the server-level principal login.

Syntax

sp_delete_firewall_rule [@name =] 'name' 
[ ; ]

Arguments

The argument of the stored procedure is:

[@name =] 'name'
The name of the server-level firewall setting that will be removed. name is nvarchar (128) with no default.

Remarks

In [!INCLUDEssSDS], login data required to authenticate a connection and server-level firewall rules are temporarily cached in each database. This cache is periodically refreshed. To force a refresh of the authentication cache and make sure that a database has the latest version of the logins table, execute DBCC FLUSHAUTHCACHE (Transact-SQL).

Permissions

Only the server-level principal login created by the provisioning process can delete server level firewall rules. The user must be connected to the master database to execute sp_delete_firewall_rule.

Example

The following example removes the server-level firewall setting named 'Example setting 1'. Execute the statement in the virtual master database.

EXEC sp_delete_firewall_rule N'Example setting 1';

See Also

Azure SQL Database Firewall
How to: Configure Firewall Settings (Azure SQL Database)
sp_set_firewall_rule (Azure SQL Database)
sys.firewall_rules (Azure SQL Database)