Hello wizards. I have a rather "simple" problem. My application creates a temporary table to do some data crunching. To clear the table before I start, I could just delete all the rows, or drop the table and recreate it. When I try to drop the temporary table (even if I am in single user mode), I get the follwing evil error message.... -ERROR- This operation cannot be performed because table MEDLIST4 is in use.(2931)
To get rid of it, I have to disconnect and reconnect the database. Is this normal? Why can't I drop a temporary table in single user mode???? TIA! Mike Sinclair
