You are required to modify a table named Sales.SalesOrder. The table has change tracking enabled on it.
You need to disable change tracking prior to modifying the Sales.SalesOrder table.
Which Transact-SQL statement should you use?
A.
EXEC sys.sp_cdc_disable_db
B.
ALTER DATABASE Contoso
SET CHANGE_TRACKING = OFF
C.
ALTER TABLE Sales.SalesOrder
DISABLE CHANGE_TRACKING
D.
EXEC sys.sp_cdc_disable_table
@source_schema = N’Sales’,
@source_name = N’SalesOrder’,
@capture_instance = N’Sales_SalesOrder’