Hi Balaji
in effort to make progress with the task I am assigned with, I went ahead and started a new query. Unfortunately I bumped into the issue that I reported here which you are helping me with as well.
(Reflection always says 'in progress')
This issue (Failing to create a reflection in SQL server) may still be there as I have not made any more effort to resolve it but I am no longer pursuing it. So we could drop this one.
Thank
Nabil