Firewall Rules Stored Procedures (Azure SQL Database)

 

Updated: July 28, 2016

THIS TOPIC APPLIES TO: noSQL Server yesAzure SQL DatabaseyesAzure SQL Data Warehouse noParallel Data Warehouse

This section contains the following stored procedures that set or delete firewall rules. Transact-SQL firewall rules can be used with SQL Database and SQL Data Warehouse. 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 SQL Server, use Window firewall rules. For more information, see Configure a Windows Firewall for Database Engine Access.

Community Additions

ADD
Show: