Edit

sp_xtp_flush_temporal_history (Transact-SQL)

  • Article

Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance

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

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