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

Does SQL Prompt work inside a SSMS Project?

I have created a SSMS project but I do not have any of my prompt functionality.  How do I get SQL Prompt to work inside of a SSMS Prjoect?


  • Options
    jadionnejadionne Posts: 5 Bronze 1
    As a follow up I do not have my sql prompt menu at the side of my script window for me to access the sql prompt functions like format code.  I also cannot hit TAB to have sql prompt auto populate column names.  I do get suggestions for table names.

  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    Hi @jadionne,

    I'm not sure if I'm understanding correctly do you mean inside SQL Server Management Studio (SSMS) or within a SQL project in Visual Studio?

    SQL Prompt should be a menu item in SSMS in the top menu bar, but in Visual Studio it will only appear when you have a .sql file opened.

    If you have installed Visual Studio after you have already installed SQL Prompt, then you will need to reinstall SQL Prompt so that it will appear in all installed products.  

    Also, just to be sure it's not the issue, the latest version of SQL Prompt supports SSMS 2012+ and Visual Studio 2015 and 2017.

    I hope that helps!

    Kind regards,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.