sys.sp_rda_reconcile_indexes (Transact-SQL)
Applies to:
SQL Server 2016 (13.x) and later versions
Queues a schema task to reconcile indexes on the remote table. After this task finishes successfully, the remote table has the same indexes that exist on the local Stretch-enabled table.
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.
If another task is queued to reconcile indexes when you call sp_rda_reconcile_indexes
, this stored procedure doesn't queue a duplicate task.
Transact-SQL syntax conventions
Syntax
sp_rda_reconcile_indexes [ @objname = ] 'objname'
[ ; ]
Arguments
[ @objname = ] 'objname'
The qualified or non-qualified name of the Stretch-enabled table for which you want to reconcile indexes. Quotes are required only if you specify a qualified object.
Return code values
0
(success) or > 0
(failure).
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om