Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.dm_federation_operation_errors (Azure SQL Database)

Returns rows containing information on errors that occur during SPLIT or DROP federation operations.

Important note Important

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.

The sys.dm_federation_operations_errors view contains the following columns.

Columns

Data Type

Description

federation_operation_id

uniqueidentifier

federation_operation_type

nvarchar(60)

Federation operation description (SPLIT or DROP)

federation_id

int

The target federation_id for the federation operation.

federation_name

sysname

Name of the federation for the given federation_id.

start_date

datetimeoffset

The UTC time when the operation was initiated.

last_modify_date

datetimeoffset

The UTC time when information on the federation operation was last updated.

percent_complete

real

The percentage of rows that have been copied when the error occurred.

Values range from 0 to 100.

error_code

int

The code indicating the error that has occurred.

error_desc

nvarchar(4000)

Description of the error that occurred.

error_severity

int

Returns 16 if the operation failed.

error_state

int

Returns 1 if the operation failed

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

For federation operations that complete successfully, all data about the operation disappears from sys.dm_federation_operations (Azure SQL Database) and sys.dm_federation_operation_members (Azure SQL Database) views. If an error is encountered during a federation operation and the operation is unsuccessful due to the error, the rows are copied from sys.dm_federation_operations (Azure SQL Database) and sys.dm_federation_operation_members (Azure SQL Database) to sys.dm_federation_operation_errors and sys.dm_federation_operation_error_members (Azure SQL Database).

Community Additions

Show:
© 2015 Microsoft