I wrote a stored procedure...and executed in Query Analyser.
It took 40min to execute....ofcourse...it is something like archieving database of millions of rows along with distributed queries....I am quite ok with the stored procedure.....(even time taking)...

But, then I executed the same stored procedure in my program using the command object which within less than a min...I am returned with the following error:

TIMEOUT EXPIRED. THE TIMEOUT PERIOD ELAPSED PRIOR TO COMPLETION OF THE OPERATION OR THE SERVER IS NOT RESPONDING.

I think the connection could not sustain till the completion of store procedure.

Can any one help me how to execute through UI.