sp_delete_firewall_rule (Windows Azure SQL Database)
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. The sp_delete_firewall_rule stored procedure is specific to Windows Azure SQL Database and is not supported in on-premise SQL Server.
Syntax Conventions (Windows Azure SQL Database)
sp_delete_firewall_rule [@name =] ‘name’
The argument of the stored procedure is:
| Name | Datatype | Description |
|---|---|---|
|
[@name =] ‘name’ |
NVARCHAR(128) |
The name of the server-level firewall setting that will be removed. |
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 code 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'
