Skip to content

firewall-rules-stored-procedures-azure-sql-database.md

Latest commit

 

History

History
36 lines (28 loc) · 2.13 KB

firewall-rules-stored-procedures-azure-sql-database.md

File metadata and controls

36 lines (28 loc) · 2.13 KB
title Firewall Rules Stored Procedures
titleSuffix Azure SQL Database
ms.date 07/28/2016
ms.service sql-database
ms.reviewer
ms.topic language-reference
dev_langs
TSQL
helpviewer_keywords
firewall rules stored procedures
firewall_rules, setting
firewall_rules, Azure SQL Database
firewall systems, Azure SQL Database
ms.assetid 3d4c2585-00de-46b5-8eee-0efb71cb3aea
author VanMSFT
ms.author vanto
ms.custom seo-dt-2019
monikerRange = azuresqldb-current || = azure-sqldw-latest || = sqlallproducts-allversions

Firewall Rules Stored Procedures (Azure SQL Database)

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

This section contains the following stored procedures that set or delete firewall rules. [!INCLUDEtsql_md] firewall rules can be used with [!INCLUDEssSDS_md] and [!INCLUDEssSDW_md]. For more information, see Configure Azure SQL Database firewall rules - overview.
sp_set_firewall_rule (Azure SQL Database) sp_delete_firewall_rule (Azure SQL Database)
sp_set_database_firewall_rule (Azure SQL Database) sp_delete_database_firewall_rule (Azure SQL Database)

For [!INCLUDEssNoVersion_md], use Window firewall rules. For more information, see Configure a Windows Firewall for Database Engine Access.