What are the challenges you face when working across database platforms? Take the survey

Suggestion Order Changes

MikeyCMikeyC Posts: 249 Bronze 3
edited December 2, 2009 2:49PM in SQL Prompt Previous Versions
I am using SQL Prompt and have noticed that the order of the suggestions changes when it shouldn't.

For instance try this:
FROM msdb.dbo.backupfile B
	INNER JOIN msdb.dbo.<cursor>

When you get the suggestions at this point the backupfile suggestion is all the way at the bottom of the table list, it is no longer in alphabetical order. It is very annoying that you can't predict where a suggestion is going to be.


  • Options
    Thanks for your post.

    The reason the table is at the bottom of the list is because once you have referenced a table, SQL Prompt assumes that it's the last table you would want to reference again. I guess they didn't think about self joins :)

    I have logged this as a bug with SQL Prompt 4. Hopefully it will be addressed in a future version.

    For your reference the bug tracking code for this issue is SP-2882.
Sign In or Register to comment.