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).