Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2016 (13.x) and later versions
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
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.