Competition: What’s your favorite Redgate tool? Enter now.

SQL Prompt not working for Synonyms

mandrewsmandrews Posts: 1 New member
we are not getting suggestions for synonyms.  SSMS 2016, SQL Prompt 10.3.1
Tagged:

Answers

  • Hi @mandrews

    Sorry to hear you're experiencing this issue!

    I've done a couple of tests with SSMS 2016 and 2017 using SQL Prompt 10.3.1 and had no issues.

    Could you check a few things for me?

    • Have you refreshed suggestions
    • Have suggestions enabled
    • In Options > Suggestions > Behaviour - Is "Automatically show suggestions after x milliseconds" on
    • In Options >  Connections > is "load suggestions for synonyms" ticked
    • Do you also have suggestions for all databases enabled or at least for the database in question

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our Help Center?

Sign In or Register to comment.