Don't drop temporary tables. Just reconnect to you database and all temporary tables and views go away. Nice and clean.
-- Dennis McGrath mailto:[EMAIL PROTECTED] -- Productivity Tools for R:Base Programmers http://www.enteract.com/~mcgrath/dennis -- Full time consultant with: SQL Resources Group Steve Hartmann Oak Park, IL mailto:[EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Goldberg Sent: Tuesday, November 20, 2001 12:58 PM To: Rbase-L Subject: Problem creating and dropping tables 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
