Eksportuj (0) Drukuj
Rozwiń wszystko
EN
Ta zawartość nie jest dostępna w wymaganym języku. Wersja w języku angielskim znajduje się tutaj.
Ten temat nie został jeszcze oceniony - Oceń ten temat

sys.database_firewall_rules (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 sys.database_firewall_rules.

Returns information about the database-level firewall settings associated with your Microsoft Windows Azure SQL Database.

The sys.database_firewall_rules view contains the following columns:

 

Column name Data type Description

id

INTEGER

The identifier of the database-level firewall setting.

name

NVARCHAR(128)

The name you chose to describe and distinguish the database-level firewall setting.

start_ip_address

VARCHAR(50)

The lowest IP address in the range of the database-level firewall setting. IP addresses equal to or greater than this can attempt to connect to the SQL Database instance. The lowest possible IP address is 0.0.0.0.

end_ip_address

VARCHAR(50)

The highest IP address in the range of the firewall setting. IP addresses equal to or less than this can attempt to connect to the SQL Database instance. The highest possible IP address is 255.255.255.255.

noteNote
Azure connection attempts are allowed when both this field and the start_ip_address field equals 0.0.0.0.

create_date

DATETIME

UTC date and time when the database-level firewall setting was created.

noteNote
UTC is an acronym for Coordinated Universal Time.

modify_date

DATETIME

UTC date and time when the database-level firewall setting was last modified.

This view is available in the master database and user databases.

Czy oceniasz te materiały jako pomocne?
(Pozostało znaków: 1500)
Dziękujemy za opinię.

Zawartość społeczności

Dodaj
Pokaż:
© 2014 Microsoft. Wszelkie prawa zastrzeżone.