Articles
Sort by recent activity
Entra ID MFA Authentication
SQL Prompt now uses a dedicated Microsoft Entra ID application to authenticate users to Azure SQL Database instances.The permissions requested are limited to those required to access the database a...
Activating your Redgate Monitor Enterprise trial license
To ensure that the enterprise tier is recognized, please activate your trial key using the 'Allocate you licenses' option rather than the perpetual serial activation method.
If you've already tried...
Redgate Monitor migration guide to version 14
Version 14 of Redgate Monitor will have some breaking changes. This means that some manual changes will be needed when upgrading. Redgate is committed to making the upgrade process as seamless as r...
Installing and running SQL Prompt
To install SQL Prompt, you must have administrator privileges. If you're upgrading from a previous version, the installer does all the preparation for you.
Installing SQL Prompt
When you run the SQ...
SSMS Tab Management
SQL Prompt's Tab History keeps a history of the query windows (tabs) that you open in SSMS, and saves their contents in response to certain actions. You can use it to track down scripts that you fo...
SQL Refactoring
You can use SQL Prompt to perform the following types for database and code refactoring:
SQL Prompt Actions
Refactoring an Object or Batch
Refactoring Databases
Refactoring Queries and Query Res...
SQL Code Snippets
A snippet is any pre-defined block of code, which you can insert into a query pane at the current cursor position, or around currently selected SQL text. SQL Prompt comes with many pre-defined snip...
SQL Code Formatting and Styles
Formatting and styles are all about taking some code and making sure that it is easy to read and understand. Formatting or style changes are 'decorative' changes that affect only whitespace, such a...
SQL Code Completion and IntelliSense
SQL Prompt offers as-you-type IntelliSense and code completion suggestions, as well as providing other information, and helping you navigate around your code. As you accept and insert the suggested...
SQL Code Analysis
SQL Prompt comes with a list of static code analysis rules you can run on your queries, as you review them, or as you type them. Static Code analysis parses the code as a compiler would, but with t...