>>I looked at every function in SP and found only a few which didn't use DatabaseName!TableName.
>>Most of our functions used it already. I guess, we need to change few functions to use database
>>prefix and this would solve our problem.
>
>Okay, otherwise you could set database in a hook SP you always call. If you don't have it, it's of course rather useless to introduce some hook procedure, as you can have solve the problem with a single line SET DATABASE TO... within each SP.
>
>Then again, a hook procedure is always nice to solve other general problems/settings etc.
>
>Bye, Olaf.
Hi Olaf,
I found out that Stonefield manager was setting database. Today we faced problem with all our users, so we had to cut the new executable and uncommment the commented managers.
Anyway, instead of instantiating Stonefield manager I just set the database in our application object.
If it's not broken, fix it until it is.
My Blog