Thanks indeed for your prompt guidance.

I have got a link (see below) from one of my friends which appears to be very helpful in setting up CDC in SQL....