Deutsch

Hintergrund

English

Background

SQL Script

Deutsch

Hintergrund

Um das Change Tracking des SQL-Servers gezielt für alle Tabellen (oder bestimmte Tabellen) zu deaktivieren , empfiehlt sich ein T-SQL Script.

English

Background

To disable SQL Server Change Tracking in a targeted manner for all tables (or specific tables) , a T-SQL script is recommended.

SQL Script

-- Finds all tables with change tracking and disables the change tracking for those tables.

DECLARE @sql NVARCHAR(MAX) = N''

SELECT @sql += N'ALTER TABLE ' + QUOTENAME(s.name) + N'.' + QUOTENAME(t.name) 
+ N' DISABLE CHANGE_TRACKING;' + CHAR(13)
FROM sys.change_tracking_tables ctt
JOIN sys.tables t ON ctt.object_id = t.object_id
JOIN sys.schemas s ON t.schema_id = s.schema_id

IF LEN(@sql) > 0
BEGIN

  PRINT 'Disabling Change Tracking on the following tables...'

  EXEC sp_executesql @sql

  PRINT 'Done. Change Tracking disabled.'

END
ELSE
BEGIN

  PRINT 'No tables found with Change Tracking enabled.'

END

GO