> Actually I do agree with what you are saying - we could eliminate
> the stored
> procedures at some loss of efficency. But I would say that I have
> not really
> gone into so much details as to how/why we ended up taking this approach.
>
> Even if we where to adopt a different approach here - it would still be
> helpfull to understand how stored procedure can be safley created and used
> on a database with DML operations occuring also. If this is simply not
> possible then this is fair enough.
>
> Thanks
> Ryan

If you work at your current model, you just may get it working. OTOH, this
is definitely not a designed for activity and never was, in fact quie the
reverse. If you intend to persevere, then you will not get many other people
following in your footsteps.
If you read some more info about the multi-generational nature of the server
and files and the design for the use of DML, DDL, transaction isolation etc.
I think you will only conclude that doing this sort of thing is not what was
designed for in the server and you will not get good reliable service from
your application with this design.
Alan