sp_xtp_flush_temporal_history (Transact-SQL)

APPLIES TO: YesSQL Server 2016 and later YesAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

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

Topic link icon Transact-SQL Syntax Conventions


sys.sp_xtp_flush_temporal_history @schema_name, @object_name  


The schema name for the current or temporal table

The name of the current or temporal table

Return Code Values

0 (success) or >0 (failure)


Requires db_owner permissions.

See Also

Performance Considerations with Memory-Optimized System-Versioned Temporal Tables