change-tracking-stored-procedures-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	dev_langs
Change Tracking stored procedures (Transact-SQL)	Change Tracking stored procedures (Transact-SQL)	JetterMcTedder	bspendolini	randolphwest	08/21/2024	sql	system-objects	reference	system stored procedures [SQL Server], change tracking change tracking [SQL Server], stored procedures	TSQL

Change Tracking stored procedures (Transact-SQL)

[!INCLUDE SQL Server]

Change Tracking is a lightweight solution that provides an efficient data change tracking mechanism for applications, ETL processes, event capture, and auditing. This allows for quick and basic detection of changed data without the need for expensive and complex custom solutions traditionally involving a combination of triggers, timestamp columns, new tables to store tracking information, and cleanup processes.

Stored procedures

• sys.sp_flush_commit_table (Transact-SQL)
• sys.sp_flush_commit_table_on_demand (Transact-SQL)
• sys.sp_flush_CT_internal_table_on_demand (Transact-SQL)

Related content

• About Change Tracking (SQL Server)
• Troubleshoot change tracking auto cleanup issues
• Change Tracking Functions (Transact-SQL)
• Change Tracking tables (Transact-SQL)