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

SQL Prompt

Entra ID MFA Authentication
SQL Prompt now uses a dedicated Microsoft Entra ID application to authen...
SQL History is greyed out
After upgrading SQL Prompt you may find that SQL History and Intellisens...
SQL Prompt missing from toolbar after installation
 Go to Extensions > Customize Menu > Extensions Menu > and uncheck both ...
Add SQL History to a shared folder
Following these steps will enable you to relocate the SQL History file t...
Error: Something went wrong while signing in. Authentication failed.
You get the error 'Something went wrong while signing in. Authentication...
Migrating snippets, styles and SQLHistory to another installation
If you want to move snippets from one installation of SQL Prompt to anot...
Installing and running SQL Prompt
To install SQL Prompt, you must have administrator privileges. If you're...
Installing/Activating SQL Prompt from the .msi File
If you'd like to install SQL Prompt from the .msi file and activate the ...
SSMS Tab Management
SQL Prompt's Tab History keeps a history of the query windows (tabs) tha...
SQL Refactoring
You can use SQL Prompt to perform the following types for database and c...
SQL Code Snippets
A snippet is any pre-defined block of code, which you can insert into a ...
SQL Code Formatting and Styles
Formatting and styles are all about taking some code and making sure tha...
SQL Code Completion and IntelliSense
SQL Prompt offers as-you-type IntelliSense and code completion suggestio...
SQL Code Analysis
SQL Prompt comes with a list of static code analysis rules you can run o...
SQL Prompt: Features available only in SQL Toolbelt Essentials
Some features of SQL Prompt are only available if you have a SQL Toolbel...
Moving snippets to another machine - SQL Prompt
Here's some steps on how to move your snippets to a different machine. L...
Error: Windows could not start the Redgate Client service on Local Computer. Error 1067: The process terminated unexpectedly
You receive the following installation error regarding Redgate Client Se...
SQL Prompt crashing SSMS
Here's some suggestions if SSMS is crashing when you try to use SQL Prom...
“Access to the path ‘XXXX’ is denied" or "Object reference is not set to instance of an object."
Common causes for this exception upon opening SSMS are: The format styl...
Root element is missing
You may get the 'root element is missing' error message if some of the X...
SSMS native IntelliSense doesn't work after SQL Prompt trial expires
If you decide not to purchase a license after a SQL Prompt trial expires...
Overlapping SSMS query windows
When toggling between SSMS query tabs, the query text does not change an...
'Encapsulate As New Stored Procedure' doesn't include variables as parameters
SQL Prompt's Encapsulate As New Stored Procedure feature allows you to c...
SQL Prompt is not showing in Visual Studio
After installing SQL Prompt successfully in Visual Studio, it will only ...
Changing screen size for SQL Prompt Suggestions
If you would like to change the screen-width display for SQL Prompt sugg...
Error ( Method not found: '!!0[] System.Array.Empty()' ) in SQL Prompt
Visual Studio / Sql Server Management Studio crashes on startup. Error t...
Installation stuck at 99%
This article applies to other Redgate products as well. If your upgrade ...
SSMS is very slow with SQL Prompt installed
To isolate the problem, please uninstall SQL Prompt and test if SSMS is ...
Changing the Code Analysis Highlight Color
This article helps with changing the color of the Code Analysis underlin...
SSMS plug-ins (SQL Prompt, SQL Search, SQL Source Control, SQL Test) are missing from SSMS
There are several reasons why one of the SSMS plug-in tools may not appe...