CODEWITHSUNDEEP
sql-serverazure-sql-database
helpME1986
helpME1986

Reputation: 1013

Where is the information about database firewall rules stored in Azure?

Where is the information about database firewall rules stored in Azure?

I executed below line on Azure SQL Database EXECUTE sp_set_database_firewall_rule N'database firewall','x.x.x.x','x.x.x.x';

I worked and I got information that one row was affected. Where is this row?

Upvotes: 0

Views: 1217

Answers (2)

helpME1986
helpME1986

Reputation: 1013

SELECT * FROM sys.firewall_rules shows the firewall settings at the server level. Fortunetaly I found what i wanted executing: 

SELECT * FROM sys.database_firewall_rules

I did not have to switch context to the master database.

Upvotes: 4

S.Karras
S.Karras

Reputation: 1493

Change your context to the master database and execute the following:

SELECT * FROM sys.firewall_rules

Upvotes: 0

Related Questions