Hi Gail,

Simple he wants to improve performance (as told by the development team). The application is quite old, and the existing db design dose not suit the current requirement. Simple example - for generation of reports the developers have written dynamic queries, linking multiple db's and storing the query in MS-Access, and then creating a View in SQL Server and execute them to display the report. Sorry, it looks very confusion, but that's what I had understood on having discussion with the development team for the last 2 weeks. Now, I have another 10 days left to do miracles :hehe:

Regards,

Sai Viswanath