Qualify Object Names and temp tables

dslinn@gms.ca

I recently discovered the qualify object names function and that it adds brackets around my database objects, but it seems to be having a problem with temp tables. Regardless of whether I perform an INSERT INTO or a SELECT * INTO, when I run the Qualify Object Names on the sproc, I get error "SQL Prompt was unable to complete this operation. Problem areas have been highlighted" and every temp table reference has a red underline and the tooltip message is "The object [#IndividualOptionBank] could not be found in the database.". And while this is obvious (it is a temp table after all), shouldn't the routine understand that?

I am using v5.2.0.5.

Anu D

Many thanks for your post and apologies for inconvenience caused.

I have logged the issue in our internal tracking system whose tracking id is SP-4179.

I will update you as soon as there are any updates on this issue.

Is there anything else I can help you with?

dslinn@gms.ca

Thanks. I really like this feature (and product) and anything I can do to help, let me know.

jmeyer

I can cofirm the same issue with both local/global temp tables as well as tables accessed via linked servers. SQL Prompt version is 5.2.0.5

rhodrie

This is still an issue in SQL Prompt 5.3.2.2
Also it does not recognise ROW_NUMBER()