Sample Scripts for Enabling or Disabling SQL Server Change Data Capture
If you use Microsoft SQL Server Enterprise Edition sources and do not run the Server Manager on the source database system, you must enable SQL Server Change Data Capture manually by running an SQL script before you create a configuration. Use the sample scripts in this appendix as a basis for creating a script that enables or disables Change Data Capture.
Copy and customize the sample script for your SQL Server database. Replace the following variables with the values that reflect your environment: