Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sp_delete_firewall_rule (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see sp_delete_ firewall_rule.

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 (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'

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.