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 TransactSQL
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’