SalesBuy

1-855-856-7678
Technical SupportSupport
Sign in

Free Trial *Internet Service Required

Windows Azure

SQL Database

Transact-SQL Reference

System Views

sys.bandwidth_usage

sys.database_connection_stats

sys.database_usage

sys.databases

sys.dm_database_copies

sys.dm_db_index_operational_stats

sys.dm_db_index_physical_stats

sys.dm_db_index_usage_stats

sys.dm_db_missing_index_columns

sys.dm_db_missing_index_details

sys.dm_db_missing_index_groups

sys.dm_db_missing_index_group_stats

sys.dm_db_objects_impacted_on_version_change

sys.dm_db_partition_stats

sys.dm_db_wait_stats

sys.dm_exec_cached_plans

sys.dm_exec_connections

sys.dm_exec_describe_first_result_set

sys.dm_exec_describe_first_result_set_for_object

sys.dm_exec_procedure_stats

sys.dm_exec_query_memory_grants

sys.dm_exec_query_plan

sys.dm_exec_query_stats

sys.dm_exec_requests

sys.dm_exec_sessions

sys.dm_exec_sql_text

sys.dm_exec_text_query_plan

sys.dm_exec_trigger_stats

sys.dm_operation_status

sys.dm_tran_active_transactions

sys.dm_tran_database_transactions

sys.dm_tran_locks

sys.dm_tran_session_transactions

sys.dm_federation_operations

sys.dm_federation_operation_members

sys.dm_federation_operation_errors

sys.dm_federation_operation_error_members

sys.event_log

sys.federations

sys.federation_distributions

sys.federation_members

sys.federation_member_distributions

sys.federation_history

sys.federation_distribution_history

sys.federation_member_history

sys.federation_member_distribution_history

sys.federated_table_columns

sys.firewall_rules

sys.database_firewall_rules

sys.resource_usage

sys.resource_stats

Minimize

This topic has not yet been rated - Rate this topic

sys.federation_member_distributions (Windows Azure SQL Database)

Returns distribution information about members within a federation. Sys.federation_member_distributions 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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.

facebook page visit twitter rss feed newsletter