More on this from VB Code side of it, I am hesitating to post this content as it is more to do with VB rather than SQL,

When the stored procedure...

Thanks for your reply!!!

Dinakar,

Actually connection time out is long enough for this!! 

Mark,

Thanks for suggestion, I will try to tune indexes though i...