Change Tracking stored procedures (Transact-SQL)
Applies to: 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 simple 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
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for