Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_delete_firewall_rule (Azure SQL Database)

sp_delete_firewall_rule (Azure SQL Database)


Updated: August 6, 2015

Applies To: SQL Server 2014, SQL Server 2016 Preview

Removes server-level firewall settings from your SQL Database server. This stored procedure is only available in the master database to the server-level principal login.

Applies to: Azure SQL Database, Azure SQL Data Warehouse Public Preview.

sp_delete_firewall_rule [@name =] 'name'

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.

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.

The following example removes the server-level firewall setting named 'Example setting 1'.

-- Remove example server-level firewall setting
EXEC sp_delete_firewall_rule N'Example setting 1';

Community Additions

© 2015 Microsoft