temporal-table-sp-xtp-flush-temporal-history.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
sp_xtp_flush_temporal_history	Invokes the data flush task to move all committed rows from in-memory staging table to the disk-based history table.	markingmyname	maghan	randolphwest	07/29/2024	sql	system-objects	conceptual	sp_xtp_flush_temporal_history sp_xtp_flush_temporal_history_TSQL sys.sp_xtp_flush_temporal_history sys.sp_xtp_flush_temporal_history_TSQL	sp_xtp_flush_temporal_history	TSQL	=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current

sp_xtp_flush_temporal_history (Transact-SQL)

[!INCLUDE sqlserver2016-asdb-asdbmi]

Invokes the data flush task to move all committed rows from in-memory staging table to the disk-based history table.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sys.sp_xtp_flush_temporal_history
    [ @schema_name = ] N'schema_name'
    , [ @object_name = ] N'object_name'

Arguments

[ @schema_name = ] N'schema_name'

The schema name for the current or temporal table.

[ @object_name = ] N'object_name'

The name of the current or temporal table.

Return code values

0 (success) or > 0 (failure).

Permissions

Requires db_owner permissions.

Related content

• Memory-optimized system-versioned temporal table performance