Disable Change Tracking with CDC
Complete the following steps to stop tracking data changes using CDC:
-
Connect to your PCS database using Microsoft SQL Server Management Studio.
-
Create a new query to enter SQL commands.
-
Enter the following text in the Query pane:
exec configureChangeTrackingCDCSettings @enableCDC = 0
-
Select the entered text and click Execute.
-
Disable change history for PCS by clicking to clear the Change History check box in Options. If change history was already disabled, update the setting by clicking to select the Change History check box and then clicking to clear the check box again.