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