Stretch Database - sys.dm_db_rda_schema_update_status
Applies to:
SQL Server 2016 (13.x) and later versions
Contains one row for each schema update task for the remote data archive of each Stretch-enabled table in the current database. Tasks are identified by their task ids.
Important
Stretch Database is deprecated in SQL Server 2022 (16.x) and Azure SQL Database. This feature will be removed in a future version of the Database Engine. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
sys.dm_db_rda_schema_update_status
is scoped to the current database context. Make sure you are in the database context of the Stretch-enabled table for which you want to see schema update status.
Column name | Data type | Description |
---|---|---|
table_id | int | The ID of the local Stretch-enabled table whose remote data archive schema is being updated. |
database_id | int | The ID of the database that contains the local Stretch-enabled table. |
task_id | bigint | The ID of the remote data archive schema update task. |
task_type | int | The type of the remote data archive schema update task. |
task_type_desc | nvarchar | The description of the type of the remote data archive schema update task. |
task_state | int | The state of the remote data archive schema update task. |
task_state_des | nvarchar | The description of the state of the remote data archive schema update task. |
start_time_utc | datetime | The UTC time at which the remote data archive schema update started. |
end_time_utc | datetime | The UTC time at which the remote data archive schema update finished. |
error_number | int | If the remote data archive schema update fails, the error number of the error that occurred; otherwise, null. |
error_severity | int | If the remote data archive schema update fails, the severity of the error that occurred; otherwise, null. |
error_state | int | If the remote data archive schema update fails, the state of the error that occurred; otherwise, null. The error_state indicates the condition or location where the error occurred. |