I have a command
that creates a temporary table.
drop table costtemp
nocheck
create temporary table costtemp (serial int)
create temporary table costtemp (serial int)
First it drops the
table in case something happened.
It works sometimes
and doesn't other times. It gives me the multi-user error
message
"Resources required
by command are not available" with the "retry" and "cancel"
buttons.
Then gives me the
error
"Unavailable
resource encountered during DROP command(2440)."
What is unusual is
if I turn off the "error messages" setting it will most of the time work. But if
I turn on the "error messages" it will never work.
Since it is a
temporary table it shouldn't be concerned with multi-user issues.
Anybody have
ideas??
I am using window
version 6.5+ 1839XRT03
Dan
Goldberg
