> PS> So if you have SP 'A' that uses SP 'B', SP 'B's code is
> PS> compiled into SP 'A'.. You can change SP 'B' as much as you want, but

until

> PS> you re-compiler SP 'A', it still uses the old version of SP 'B'.
>
> that's not my experience; are you sure?

That is not true.

As soon as the last user disconnects from the database SP A will use
the new code from SP B. If you want however the new code to take
effect immediately you also have to recompile SP A.

Regards,
Frank.