Script to Enable and use CDC in MS SQL Server

Recently at a training I was asked about CDC and while this script is old and previously published I couldn’t find it within the blog after I migrated to Azure. So re-posting. Enjoy !! USE MADWORKS GO –THIS ENABLES CDC ON THE DATABASE sys.sp_cdc_enable_db GO — CREATING A SCHEMA AND TABLE TO BE USED IN…