You can enable Change Data Capture of a SQL Server database using below T-SQL Statement.
Use [YourDatabase_name]
EXEC sys.sp_cdc_enable_db
GO
Use [YourDatabase_name]
EXEC sys.sp_cdc_enable_db
GO
TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.
No comments:
Post a Comment