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

SQL Prompt

Entra ID MFA Authentication
SQL Prompt now uses a dedicated Entra ID application to authenticate use...
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...
Why SQL Prompt?
Alongside specialists, an IT department needs people who are broadly ski...
About SQL Prompt
SQL Prompt is an add-in for SQL Server Management Studio and Visual Stud...
SQL Prompt Requirements
SQL Prompt is an add-in for the following development environments: SQL...
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 ...
Managing SQL Prompt behavior
You can set various options for how SQL Prompt behaves in the SQL Prompt...
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...
Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=16.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies
If you're getting the following error message in SSMS: Could not load fi...
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 ...