SQL Server call timeout

[Techno]

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.

[Techno]

even with a bit of clear up on the SPROC itself..... it still seems to timeout but in QA, again, takes 3/4 seconds to get the results back but "hangs" in .NET when reading the data.