Monthly Archives: July 2016

Script to Enable and use CDC in MS SQL Server

By | July 12, 2016

Recently at a training I was asked about CDC and while this script is old and previously published i couldnt find it within the blog after I migrated to Azure. So re-posting. Enjoy !! [codesyntax lang=”tsql”] USE MADWORKS GO –THIS ENABLES CDC ON THE DATABASE sys.sp_cdc_enable_db GO — CREATING A SCHEMA AND TABLE TO BE… Read More »