• Alright, now we are getting some where. If you are using cdc, you should enable and run the CDC jobs. There should be capture and cleanup jobs. The capture job should run continuously and the cleanup job should run daily. Now if you REALLY want to disable CDC, you can run the following.

    USE <dbname>

    GO

    EXEC sys.sp_cdc_disable_db

    GO

    If this doesn't work, you may have to manually remove CDC. This article describes the process.

    http://www.mssqltips.com/sqlservertip/3003/manual-cleanup-change-data-capture-for-a-sql-server-database

    Edit - link came up wrong