Articles
Sort by recent activity
WARNING: An expired Flyway license key was provided; fell back to Community Edition.
You have a supported Flyway license and you're seeing this error message:WARNING: An expired Flyway license key was provided; fell back to Community Edition.This is because you have supplied a stat...
SQL History is blank
Navigate to %localappdata%\Red Gate\SQL Prompt 11\SqlHistoryIndex and rename the SQLHistory.db file to something like "SQLHistory_OLD".Then re-open SSMS and a new SQLHistory.db file should be creat...
Unable to access SQL Prompt AI features
If your licence is perpetual you won't be able to access the SQL Prompt AI features. These features are only available with a subscription license.Prior to version 11.1, Prompt AI was available thr...
An error has occurred in the script on this page
You're seeing the error message "An error has occurred in the script on this page".Here's some steps you can try to resolve it:
Open the tool
Using Chrome/Edge, navigate to http://localhost:22221/r...
Failed to fetch, decode or validate the licensing permit
You run into this error when activating your license:Ensure that all the endpoints in this article are added to your AllowList:Licensing & update URLs to add to your AllowList in firewall
How to view my support tickets
To view your support ticket history, log in to the Redgate support site and click on 'Sign in'.https://productsupport.red-gate.com/hc/en-usLog in with your Redgate ID:Click on the account icon > Re...
SQL History is greyed out
After upgrading SQL Prompt you may find that SQL History and Intellisense appear to be disabled. To fix this, on the SQL Prompt menu click on SQL Prompt > Manage my license > and sign in with your ...
Single sign-on (SSO) for Redgate apps
Single sign-on (SSO) allows users of Redgate apps to authenticate using their organization's identity provider, removing the need for them to use a Redgate ID and password.SSO removes the need for ...
SQL Prompt missing from toolbar after installation
Go to Extensions > Customize Menu > Extensions Menu > and uncheck both SQL Prompt options, then Save and Restart. SQL Prompt should then show in the toolbar.
Add SQL History to a shared folder
Following these steps will enable you to relocate the SQL History file to a shared folder.1. Open regedit2. Go to Computer\HKEY_CURRENT_USER\Software\Red Gate\SQL Prompt 10\3. Add a string value wi...