Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Massive Intellisense Drop-Down with SQL Prompt

At some point in past few versions of SQL Prompt, the Intellisense drop-down menu has become massively wide, spanning multiple monitors. The menu starts at the left edge of whatever window SQL Server Management Studio happens to be on, and continues across all monitors until it reaches the right-most edge of the right-most monitor. It appears that the width of the drop-down is ALWAYS the entire total width of all my monitors together, such that if I have SSMS on the leftmost monitor, I can see the scrollbar for the drop-down on the right-most monitor, but if the SSMS is on any other monitor, then the drop-down's rightmost edge extends off the visible portion of the monitors and is not visible.

If I turn off the SQL Prompt "Enable Suggestions" option, then the native Intellisense of SSMS seems to work just fine, putting up the (normal sized) short list of suggested items. Turn on SQL Prompt "Enable Suggestions" again, and boom! it goes right back to massively over-wide mode.

Any suggestions or ideas on this one?

Best Answer

  • Russell DRussell D Posts: 1,324 Diamond 5
    You can change the size of this by editing the 

    %LOCALAPPDATA%\Red Gate\SQL Prompt 9\RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml file.

    Take a look at the CandidateListWidth and CandidateListHeight​.

    Have you visited our Help Centre?


  • GibsonCRGGibsonCRG Posts: 3 Bronze 1
    Worked like a charm! Thank you very much!
  • cmedcoffcmedcoff Posts: 3 New member
    edited April 15, 2022 1:20PM
    This didn't work for me.  In fact after trying I took a backup and delete the file and it's still massive. Redgate help!
  • BrennanRPopeBrennanRPope Posts: 1 New member
    edited June 20, 2022 6:22PM
    Running into this problem as well in SSMS. I shouldn't have to go to my app data folder to fix this. I found that there is a handle at the bottom right corner of the suggestions drop down that is your only way to modify these fields in the UI, but if for some reason, the handle goes off the screen because it gets too large, there is no way to resize. What should happen is that when there is a change in the display settings, or if there is a minimize/restore down of the window, then the property is reset to a reasonable amount with respect to the monitor displaying SSMS
Sign In or Register to comment.