title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.sp_xtp_merge_checkpoint_files (Transact-SQL) |
Merges all data and delta files in the transaction range specified. |
markingmyname |
maghan |
randolphwest |
06/14/2023 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE sqlserver]
Merges all data and delta files in the transaction range specified.
Note
This stored procedure is deprecated in [!INCLUDE sssql16-md]. It is no longer needed, and cannot 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 (Transact-SQL) 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 (Transact-SQL). 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.