Dan, Do you have a cursor declared against the table?
Ben Petersen On 20 Nov 2001, at 10:57, Dan Goldberg wrote: > I have a command that creates a temporary table. > > drop table costtemp nocheck > 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 > >
