> There are a few cases where the whole chain of dependent sps &
> triggers need recompilation whenever a certain sp changes. For
> instance, today I had a sp which's execution got a "multiple rows in
> singleton" error. After fixing it, all its callers (sps & triggers
> alike) kept insisting on executing the old version of the procedure.
> Only executing the sp directly worked. I use 2.1.2.
>
> I'm sure it happen this before, but didn't had time to investigate. I
> just got used to recompiling everything.
>
> So the question is, is this a known bug or should I try and make up a
> more detailed report (eg. with a db attached, or sumth) ?

This is well-known "by-desing" limitation. Read chapter "altering procedures
in use" in IB6 docs.

Regards,
Vlad