Gratis proefversie *Internet Service Required
EN
Deze inhoud is niet beschikbaar in uw taal, maar wel in het Engels.
Dit onderwerp heeft nog geen beoordeling - Dit onderwerp beoordelen

sys.firewall_rules (Windows Azure SQL Database)

Returns information about the server-level firewall settings associated with your Microsoft Windows Azure SQL Database. The sys.firewall_rules view is specific to Windows Azure SQL Database and is not supported in on-premise SQL Server.

The sys.firewall_rules view contains the following columns:

 

Column name Data type Description

id

INTEGER

The identifier of the server-level firewall setting.

name

NVARCHAR(128)

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

start_ip_address

VARCHAR(50)

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

end_ip_address

VARCHAR(50)

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

noteNote
Windows 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 server-level firewall setting was created.

noteNote
UTC is an acronym for Coordinated Universal Time.

modify_date

DATETIME

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

Read-only access to this view is available to all users with permission to connect to the master database.

Vindt u dit nuttig?
(1500 tekens resterend)

Community-inhoud

Toevoegen
© 2013 Microsoft. Alle rechten voorbehouden.
facebook page visit twitter rss feed newsletter