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

Syntax


sys.sp_xtp_flush_temporal_history @schema_name, @object_name  

Arguments

@schema_name
The schema name for the current or temporal table

@object_name
The name of the current or temporal table

Return Code Values

0 (success) or >0 (failure)

Permissions

Requires db_owner permissions.

See Also

Performance Considerations with Memory-Optimized System-Versioned Temporal Tables