After installing SQL Prompt successfully in Visual Studio, it will only show up in VS when you open a SQL file (or a SQL Server Object Explorer window). This is due to a restriction from Microsoft that requires plugins to be loaded asynchronously. This behavior changed in SQL Prompt 9.1.8.
NOTE: SQL Prompt in VS is only supported for SQL files, not for SQL code in other types of files.
Sometimes after upgrading, SQL Prompt disappears from Visual Studio.
- Open Add or Remove Programs
Click on SQL Prompt and select Uninstall
- Install the latest version of the tool