Board index MS SQL Server

Internal error -- Unable to open table at query execution time.

Internal error -- Unable to open table at query execution time.

Post by Jung Patric » Tue, 20 Jun 2000 04:00:00



hallo,

What can I do to avoid this message.

I created a stored procedure on a SQL-Server 6.5 (SQL-SP 5 german) in a
database.
When I tried to execute (in the query-box) this procedure the following
message appears:

    internal error -- Unable to open table at query execution time.
    (in german:Interner Fehler --- konnte Tabelle w?hrend der
Abfrageausfhrung nicht ?ffnen.)

When I browse into the database and browse into the properties of this
procedure and save the procedure without changes then it runs once with
success. But the second and the following tries faile.

Has somebody an idea?

greetings
P. Jung

 
 
 
Top

Internal error -- Unable to open table at query execution time.

Post by Jung Patric » Tue, 20 Jun 2000 04:00:00


hallo,

what can I do to avoid this message.

I created a stored procedure on a SQL-Server 6.5 (SQL-SP 5 german) in a
database.
When I tried to execute (in the query-box) this procedure the following
message appears:

    internal error -- Unable to open table at query execution time.
    (in german:Interner Fehler --- konnte Tabelle w?hrend der
Abfrageausfhrung nicht ?ffnen.)

When I browse into the database and browse into the properties of this
procedure and save the procedure without changes then it runs once with
success. But the second and the following tries faile.

Has somebody an idea?

greetings
P. Jung

 
 
 
Top

1. Msg 202 Internal error -- unable to open table at query execution time

Sometimes we get error meg. 202 -- unable to open table at query execution
time. Acording to article ID: Q169376 on knowledge base, the procedure has:

1.create a permenent table
2.dop a permanent table
3.create a temporary table
4.declare a cursor on temporary table
5.drop temporary table

We do have the code for steps 3, 4, and 5 in that stored procedure. But not
for steps 1 and 2. So does this error message still apply to our situation.
Question is that this error does not happen every time.

According to Microsoft's suggestion we can use "with recompile" to work
around this problem. But this is a no-no because it defeat the purpose for
stored procedure. Any hint is appreciated.

2. total details max 10 datail lines in table

3. Unable to open table at query execution time-error

4. How To Enumerate The Tables And Fields In A Database?

5. Internal error -- Unable to open table at query execution time.

6. Famous Bridge Database

7. !!!! Internal error:Unable to open table at query execution time...

8. LISTENER -THREAD ERR:25580

9. Internal error -- Unable to open table at query execution time.

10. Help !!! Internal error: Unable to open table at query execution time

11. Msg 202 - Internal error -- Unable to open table at query execution time.

12. Internal error -- Unable to open table at query execution time.

13. Unable to open table at query execution time


All times are UTC
Board index