Update sp_add_cdc.sql

[Imran-imtiaz48]

Key changes: • Cursors fetch both schema and table name. • Avoids repeated subqueries inside loops. • Proper error handling and cursor cleanup. • Cleaner, more efficient, and easier to maintain!