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.