Do you have error handling in your SP?
>Well, the SP calles several other SP's. The first SP just processes 6 - 10 records and than quits. Next the other SP's are processed normaly, but some will fail while the first one failed.
>
>>The stored procedure stops processing like waiting for something or it quits in the middle of processing?
--sb--