Which Transact-SQL statement should you use?

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’

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.