sys-sp-rda-reconcile-indexes-transact-sql.md

title	sys.sp_rda_reconcile_indexes (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.reviewer
ms.technology	stored-procedures
ms.topic	language-reference
f1_keywords	sp_rda_reconcile_indexes sp_rda_reconcile_indexes_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.sp_rda_reconcile_indexes stored procedure
ms.assetid	96b31ab9-bf84-46d6-9990-81f5c51f885a
author	MikeRayMSFT
ms.author	mikeray

sys.sp_rda_reconcile_indexes (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx-md]

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.

If there is another task queued to reconcile indexes when you call sp_rda_reconcile_indexes, this stored procedure does not queue a duplicate task.

Transact-SQL Syntax Conventions

Syntax

  
sp_rda_reconcile_indexes [@objname = ] 'objname'  
  

Arguments

[@objname = ] 'objname'
Is 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)

See Also

Stretch Database