How can we help you today? How can we help you today?

Qualify Object Names and temp tables

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.
dslinn
0

Comments

4 comments

Sort by
  • 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?
    Anu D
    0
  • dslinn
    Thanks. I really like this feature (and product) and anything I can do to help, let me know.
    dslinn
    0
  • 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
    jmeyer
    0
  • rhodrie
    This is still an issue in SQL Prompt 5.3.2.2
    Also it does not recognise ROW_NUMBER()
    rhodrie
    0

Add comment

Please sign in to leave a comment.