Enable CDC for database and table

To enable CDC for database and table in that DB just do this:

USE [DatabaseName]
GO
EXEC sp_changedbowner 'sa'
GO
EXEC sys.sp_cdc_enable_db
GO

EXEC sys.sp_cdc_enable_table
    @source_schema = N'dbo',
    @source_name   = N'TableName',
    @role_name     = NULL,
    @supports_net_changes = 1
GO

That's all :)