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).