> Hi,
>
> I now have a Dr Watson log with symbols inplace from this crash.
> I can email
> this to anyone interested - it is about 900K.
> Any help on this issue at all would be greatly appreciated. I
> realise their
> is alot of room for things to go wrong - but we have been using this
> database for about two years now without problem. It just seems its
> in-capable of creating stored procedures dynamicly - and then
> using these on
> other connections. The documentation does not go into detail as to what
> should and shouldent work. I assumed that if the stored procedure
> is visible
> to the current transaction it should be OK to call the stored procedure.
> Anyhow - any sugestions would be gratefully recieved.
>
> Thanks
> Ryan
>

Can we see the code of one of these stored procedures? You seem to get
dependency problems - there must be quite something going on here.
Alan
PS I have a natural aversion to creating SPs dynamically. I create views
occasionally but I am never tempted by SPs. I would rather write my SP to
handle certain behaviour dependent on the dyanlic requirements but not
change the code.