#Temp table error

Mar 20, 2009 3 Replies

Hi everbody,



my client gets an error at opening RMS HQ Manager and it's something like this:



"The name of the object '#Temp' is not valid. SELECT * FROM #Temp WHERE [Status] IN (0,1,2,3,5,6,7)"



I have seen this before, but I'm not sure (can't remember) if there was an fix for this or workaround, or what's provoking it. ¿Any idea?



The client has an RMS v2.0 with SP2...



Thanks in advance, Antonijo


Hi everbody,

my client gets an error at opening RMS HQ Manager and it's something like this:

"The name of the object '#Temp' is not valid. SELECT * FROM #Temp WHERE [Status] IN (0,1,2,3,5,6,7)"

I have seen this before, but I'm not sure (can't remember) if there was an fix for this or workaround, or what's provoking it. ¿Any idea?

The client has an RMS v2.0 with SP2...

Thanks in advance, Antonijo

-- ADTodorovik

Hi Jeff,

Thanks for the replay. Can You be more specific, please? We searched in the PC where RMS HQ is installed and also at the server, where the DB of RMS HQ is, and have not found any *.tmp files... There is another PC, with RMS HQ installed, attacking the same server/DB, but don't think that this has anything to do with it...

Any help is welcomed. Thanks in advance...

Kind regards, A.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required