SalesBuy
1-855-856-7678
Technical SupportSupport
sys.dm_federation_operation_errors (Windows Azure SQL Database)
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 (Windows Azure SQL Database) and sys.dm_federation_operation_members (Windows 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 (Windows Azure SQL Database) and sys.dm_federation_operation_error_members (Windows Azure SQL Database).
