Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.dm_federation_operation_members (SQL Database)

Returns a list of federation members involved in federation operations.

Applies to: Windows Azure SQL Database (Initial release through current release).

The sys.dm_federation_operation_members view contains the following columns.


Data Type




Unique operation id that identifies the federation operation in the system.



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



‘Source’ or ‘Destination’

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

The primary key for this view is federation_operation_id, which contains a randomly generated value. In combination with sys.dm_federation_operations (SQL Database), this view provides information on the progress of an operation.

Information is reported as long as an operation is being executed, and is cleaned up immediately after the operation completes.

This view exists in all databases, but returns no rows in databases that do not contain federations, or do not have any ongoing operations on federations. This view also exists in federation members, but will never return rows as federation members cannot contain federations or execute federation operations.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.