Executing Stored Procedures on SQL Server

[HawgWild]

I am trying to execute a stored procedure on an MSSQL Server. I
have set my CommandTimeout value equal to zero but it the stored
procedure only handles a few records and then the
ExecuteComplete event occurs.

Does anyone know why my stored procedure will not fully complete
it's task before ending? Also, does anyone have any suggestions
on how I can temporarily hold my program while the stored
procedure is running? I do not want it to continue until the
stored procedure is complete or I will have problems.

Thanks

[Jon_COS]

did you ever get a reply on this

[InvisibleDuncan]

What does your procedure do? Is it a Select, Insert, Update...?

[Jon_COS]

What does your procedure do? Is it a Select, Insert, Update...?
Yes, Yes, and Yes.
We have a procedure that responsible to call a whole host of other procs that perform various and sundry functions of select insert and update. The main proc, with moderately sized data could take 2-3 min to process.

ps If:
It's 1440 on Monday, and everything is just fine, fine, fine.
Then:
You aint from around here then are you? Its 0900 on Monday here.

Jon