Temporal Table - sp_xtp_flush_temporal_history

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)yesAzure SQL DatabasenoAzure SQL Data Warehouse 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