have a problem here.

a client basically has a SPROC and has a good few while loops and executing other SPROCS within the SPROC which may also have some while loops.

now, this works fine (I dont recommend doing it but thats a different matter) and I can use the SqlDataReader to get the results back.

however, adding another SPROC to execute, it seems to just timeout but running it in QA takes around 4-5 seconds.

I did set the command timeout property to 60 and longer, but makes no difference.

any ideas on how to get around this problem? Like I said, it takes QA 5 seconds to execute this procedure with the new code in place.... but in C#, it times out unless we comment out this other line which executes another SPROC within the same SPROC.