Edit

Share via

sys.sp_xtp_merge_checkpoint_files (Transact-SQL)

  • Article

Applies to: SQL Server

Merges all data and delta files in the transaction range specified.

Note

This stored procedure is deprecated in SQL Server 2016 (13.x). It's no longer needed, and can't be used, starting SQL Server 2016 (13.x).

For more information, see Creating and Managing Storage for Memory-Optimized Objects.

Transact-SQL syntax conventions

Syntax

syntaxsql 
sys.sp_xtp_merge_checkpoint_files
    [ @database_name = ] database_name
    , [ @transaction_lower_bound = ] lower_bound_tid
    , [ @transaction_upper_bound = ] upper_bound_tid
[ ; ]

Arguments

[ @database_name = ] 'database_name'

The name of the database on which to invoke the merge. @database_name is sysname. If the database doesn't have in-memory tables, this procedure returns with user error. If the database is offline, it returns an error.

[ @transaction_lower_bound = ] lower_bound_tid

The bigint lower bound of transactions for a data file as shown in sys.dm_db_xtp_checkpoint_files corresponding to the start checkpoint file of the merge. An error is generated for an invalid transaction ID.

[ @transaction_upper_bound = ] upper_bound_tid

The bigint upper bound of transactions for a data file as shown in sys.dm_db_xtp_checkpoint_files. An error is generated for an invalid transaction ID.

Return code values

None.

Cursors returned

None.

Permissions

Requires sysadmin fixed server role and the db_owner fixed database role.

Remarks

Merges all data and delta files in the valid range to produce a single data and delta file. This procedure doesn't honor the merge policy.

Related content