Very Computer

I am getting an error calling a stored procedure intermitantly.  
From VB the error is reported as:

   37000: [Microsoft] [ODBC SQL Server Driver] [SQL Server] Internal Error
-
   Unable to Open Table at query execution time 40002

From ISQL/w the error is reported as:

   Msg 202, Level 11, State 2 Internal error - Unable to Open Table
   at query execution time.

The stored procedure is using temporary tables (yes I remembered to
drop the temporary tables).  I wondered if the tempdb (still set at the
default of 2MB) is too low.  Any way to check what is going wrong?

Please send help to me (copy the list if you want).

Thanks,
--

http://www.veryComputer.com/.*ia.edu/~djm5g/david.html

Good luck

Gary white

Quote:>From ISQL/w the error is reported as:

>   Msg 202, Level 11, State 2 Internal error - Unable to Open Table
>   at query execution time.

>The stored procedure is using temporary tables (yes I remembered to
>drop the temporary tables).  I wondered if the tempdb (still set at the
>default of 2MB) is too low.  Any way to check what is going wrong?

There are several workarounds. One is to stop using the cursor all-
together in favour of SELECT MIN, or SET ROWCOUNT 1. But if you
want the cursor, simply but the DECLARE statment in an EXECUTE
statement:

   EXECUTE("
     DECLARE temp_cur CURSOR FOR
        SELECT col1, col2...
        FROM   #temp...
        WHERE  ...
   ")

--

F=F6r =F6vrigt anser jag att QP b=F6r f=F6rst=F6ras.
B=65sid=65s, I think QP should b=65 d=65stroy=65d.