| title | sys.sp_xtp_merge_checkpoint_files (Transact-SQL) | ||
|---|---|---|---|
| description | Merges all data and delta files in the transaction range specified. | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE sqlserver]
Merges all data and delta files in the transaction range specified.
Note
This stored procedure is deprecated in [!INCLUDE sssql16-md]. It's no longer needed, and can't be used, starting [!INCLUDE sssql16-md].
For more information, see Creating and Managing Storage for Memory-Optimized Objects.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sys.sp_xtp_merge_checkpoint_files
[ @database_name = ] database_name
, [ @transaction_lower_bound = ] lower_bound_tid
, [ @transaction_upper_bound = ] upper_bound_tid
[ ; ]
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.
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.
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.
None.
None.
Requires sysadmin fixed server role and the db_owner fixed database role.
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.