Thanks for the reply "Old Pedant" appreciated. I learnt a lot from those few para's.
Yes actually I was referring to classic ASP, should have stated that more clearly sorry.
So in summary then, I'll make sure the VB.NET code is compiled with "option strict", and I will have a closer look at the DB calls and see what I can optimize there.
You did mention Stored Procedures, a question.. Are there security exposures around using these ?
I seem to recall someone telling me a while back that these are things targeted with SQL injection hacks etc. Or did I misinterpret what I heard.