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 TABLE Sales.SalesOrder DISABLE CHANGE_TRACKING
C. ALTER DATABASE Contoso SET CHANGE_TRACKING = OFF
D. EXEC sys.sp_cdc_disable_table@source_schema = N’Sales’,@source_name =N’SalesOrder’, @capture_instance = N’Sales_SalesOrder’