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

SQL Prompt 11 Intellisense in SQL Pools

Hi. We (data team) has installed SQL Prompt 11 with SSMS 20.2. While intellisense continues to work with a normal Azure SQL database, it still does not work with our dedicated SQL Pool. Is there a setting we are missing to enable this feature?

Justin Sanderson
1

Comments

7 comments

Sort by
  • Christian Perez
    Official comment

    Hi Justin,

     

    Thanks for reaching out to Redgate Support, sorry to hear you are having some trouble with intellisense in SQL Prompt 11. We have had a few users who have had some issues Dedicated Pools after updating, could I trouble you for your SQL Prompt Log files so I can review them and confirm you are not also being impacted? (SQL Prompt > Help > Locate Log Files)

     

    Alternatively, I have heard a few users have success toggling intellisense on and off to get things going again.

    Christian Perez
  • Justin Sanderson

    Thanks, Christian. How can I securely send the logs to you? I do not want to put them in a public forum. Should I lodge a support ticket? 

     

    Also, where is the option to toggle Intellisense on/off? 

    Justin Sanderson
    0
  • Christian Perez

    File Request You can submit the logs here for review. Please visit the following URL to send us files: https://files.red-gate.com/requests/UQm85OngUpGVd7TgPkZqX3 This link expires: Friday, 27 June.

     

     

    Christian Perez
    0
  • Christian Perez

    With respect to toggling intellisense, if you click on SQL Prompt and then click on refresh suggestions or ‘Enable Suggestions’ that should force a reconnect to be attempted by Prompt to load suggestions.

     

    Are you using Entra MFA authentication with this dedicated pool by chance?

    Christian Perez
    0
  • Justin Sanderson

    Thanks, Christian. Logs submitted. 

    Unfortunately, toggling ‘enable suggestions’ off and on did not work. Yes, we are using Entra MFA.

    @Robert, we are using 11.0.2. There is not an 11.1 that I am aware of.

    Justin Sanderson
    0
  • elonlilx

    We have had a few users who have had some issues Dedicated Pools after updating, could I trouble you for your SQL Prompt Log files so I can review them and confirm you are not also being impacted? (SQL Prompt > Help > Locate Log Files) octordle free.

    elonlilx
    0
  • Christian Perez

    Hi Justin,

     

    Thanks for following up, you will need to update to the latest version of Prompt since you are using Entra MFA, there was a fix put out in that version for Synapse Dedicated Pools and Entra MFA authentication. Keep in mind you will be prompted to accept permissions when you initially connect after updating Prompt that you will need to do, this may require an admin to approve. 

     

    You can find the download link here: https://download.red-gate.com/checkforupdates/SQLPrompt/

     

     

    Christian Perez
    0

Add comment

Please sign in to leave a comment.