Post reply

SQL SERVER 2008 CDC

  • June 22, 2009 at 7:29 am

    #201691

    Dear All

    I downloaded and installed SQL SERVER 2008 Evalution Version from site and want to test change data capture

    for that I created one database -

    CREATE DATABASE SQL2008CDC

    USE SQL2008CDC

    after this I am issuing these lines -

    EXEC sp_cdc_enable_db

    EXEC sp_cdc_enable_db_change_data_capture

    BUT unfortunately I got this ERROR-

    Msg 2812, Level 16, State 62, Line 1

    Could not find stored procedure 'sp_cdc_enable_db_change_data_capture'.

    Can any one help me I am in a big problem

    In advance Thankyou

  • June 24, 2009 at 3:27 pm

    #1014961

    There is no comand of EXEC sp_cdc_enable_db_change_data_capture. Once you execute EXEC sp_cdc_enable_db, then the CDC is enabled for the database and you can verify it by running "SELECT is_cdc_enabled, * FROM sys.databases"

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply