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

title	Firewall Rules Stored Procedures (Azure SQL Database) | Microsoft Docs
ms.custom	MSDN content MSDN - SQL DB
ms.date	07/28/2016
ms.prod
ms.reviewer
ms.service	sql-database
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
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
caps.latest.revision	10
author	BYHAM
ms.author	rickbyh
manager	jhubbard

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.