Thanks for sharing useful article link.
But could you please suggest me any automated option instead of scripting language?
Actually, scripting is about bit complicated for me and I am not much familier with this.
Thanks for advice. But Redgate seems bit costly.
However, I have also explored and discussed with several professionals for the same. And If I compare them, Lepide sql auditor comes under my budget which claims about good services of my concern. But let me check the demo either it's an appropriate or not.