Exporteren (0) Afdrukken
Alles uitvouwen
Expand Minimize
EN
Deze inhoud is niet beschikbaar in uw taal, maar wel in het Engels.
Dit onderwerp heeft nog geen beoordeling - Dit onderwerp beoordelen

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

Returns historical information about the distribution range for federation members. Sys.federation_member_distribution_history is specific to Windows Azure SQL Database and is not supported in on-premise SQL Server.

 

Columns Data type Description

federation_id

int

Reference to federation id.

member_id

int

Is the unique id to identify the federation member.

distribution_name

sysname

Reference to the federation_distribution_schemes distribution_name for the federation

range_low

sqlvariant

Low range of the key that the federation member will be servicing. The low range value is inclusive in all cases.

range_high

sqlvariant

High range of the key that the federation member will be servicing. High value range is excluded in the values serviced by the federation member.

drop_date

datetimeoffset

Datetime the federation was dropped.

create_date

datetimeoffset

Datetime the federation was created.

This view requires VIEW DATABASE STATE permission.

Cleanup of historical data is performed automatically every two weeks. Cleanup is triggered by operations that update the log information. This can result in historical information being retained for longer than two weeks if no new operations have been performed.

The drop_date and create_date columns are populated on the completion of an operation. For asynchronous operations these fields are populated when the operation completes fully, not when the command returns.

The value for federation_id is not reused within a single root database, and the value of member_id is not reused within a federation.

Vindt u dit nuttig?
(1500 tekens resterend)
Bedankt voor uw feedback

Community-inhoud

Toevoegen
Weergeven:
© 2014 Microsoft. Alle rechten voorbehouden.