Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sys.dm_federation_operation_error_members (Azure SQL Database)

sys.dm_federation_operation_error_members (Azure SQL Database)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Returns the list of members involved in federation operations that failed due to errors in Azure SQL Database.

System_CAPS_importantImportant

The current implementation of Federations will be retired with Web and Business service tiers. Consider deploying custom sharding solutions to maximize scalability, flexibility, and performance. For more information about custom sharding, see Scaling Out Azure SQL Databases.

Applies to: Azure SQL Database.

Columns

Data Type

Description

federation_operation_id

uniqueidentifier

Operation ID that failed.

member_id

int

The ID of the source or the destination member in the sys.federation_members view.

member_type

nvarchar(60)

'Source' or ‘Destination’

You must be connected to the database used to start the federation operation, and you must have VIEW DATABASE STATE permissions.

Community Additions

ADD
Show:
© 2015 Microsoft