SALES: 1-800-867-1380
Expand Minimize
This topic has not yet been rated - Rate this topic

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

Returns rows containing information on errors that occur during SPLIT or DROP federation operations. The sys.dm_federation_operations_errors view is specific to Windows Azure SQL Database and is not supported in on-premise SQL Server.

The sys.dm_federation_operations_errors view contains the following fields:

 

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 operation sthat 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 and sys.dm_federation_operation_members to sys.dm_federation_operation_errors (Azure SQL Database) and sys.dm_federation_operation_error_members (Azure SQL Database).

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.