I downloaded SSMS 18.5, as there were a lot of fixes in here and thought this was a good upgrade to try. I’d heard reports of major changes in the VS shell causing issues with various add-ins, including Redgate tools, so I decided to verify things. Especially for SQL Prompt.

Hi Redgate Team, SQL Prompt will raise an error when formatting ALTER SERVER CONFIGURATION SET MEMORYOPTIMIZED TEMPDBMETADATA=ON;GO Thanks for fixing! RedGate.SQLPrompt.exe, RedGate.SQLPrompt.TrayApp.bak.exe or Redgate.SQLPrompt.TrayApp.exe are the default file names to indicate the SQL Prompt installer. The actual developer of the software is Red Gate Software Ltd. Added the ability to download the installer instead of running it when SQL Prompt informs that there is a new version available.

Tl;dr: The SQL Prompt fix is here: http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.1.4.14671.exe

SQL Prompt and SSMS 18.5. Posted on April 8, 2020 by way0utwest. I downloaded SSMS 18.5, as there were a lot of fixes in here and thought this was a good upgrade to try. I’d heard reports of major changes in the VS shell causing issues with various add-ins, including Redgate tools, so I decided to verify things. Especially for SQL Prompt. SQL Prompt updates the cache files ready for you to use immediately. To refresh the cache file for the database you are using in your query editor, on the SQL Prompt menu, click Refresh Cache, or press CTRL+SHIFT+D. You can set SQL Prompt so that it refreshes cache files whenever you connect to a database or open a new query editor session.

As soon I installed this and started SSMS, the fun began.

This was all before the SSMS login. I connected to a database and SQL Prompt is definitely broken.

Fortunately, Redgate released a fix today, which you can download from http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.1.4.14671.exe

I downloaded that and ran the install. I also upgraded SQL Change Automation at the same time. After this, I restarted SSMS and Prompt now works.

Other fixes are on the way, as the teams are scrambling. This isn’t a big fix, but it is updating some things that changed as MS upgraded part of the shell.

The most important tool is now working. If you’ve never tried it, download SQL Prompt today and see how much faster you can write code.

Published 29 October 2019

User account licensing

Most of Redgate's products now use user account licensing, the aim of which is to give our customers more control over how they manage their licenses.

As an end user of a Redgate product, you'll see the most obvious change when you’re prompted to log in with a Redgate ID during product activation.

As the license owner (normally the person who purchased the product) or a license admin, you’ll now see a list of identified users against the product when you log in to the My Products page on the Redgate website. As well as seeing who’s actually using the licenses, you’ll also be able to remotely deactivate those identified users (for example if a person has left the company, or if the license needs to be freed up for someone else to use).

Trial period

Redgate Sql Prompt Download

When you install most Redgate products (apart from free ones), you have a trial period to evaluate them without purchase. Trial periods vary from 14 to 28 days depending on the product.

If you need more time to evaluate a product, email licensing@red-gate.com.

Managing your licenses

If you've purchased Redgate products, you can log in to the Redgate website to manage your product licenses. You'll need to log in with the email address and password you provided when you purchased the product.

After you log in, you can view details of every product you've purchased, including the number of licenses and serial numbers for each product.

For some products, you can view details of who is using each license, and deactivate those licenses from the website. This functionality is part of a series of licensing updates (see Updates to our licensing system above), and is not yet available in all products.

To see more information about who is using a license, they'll need to have logged in to that product with a Redgate ID. When users are logged in, they'll be shown as identified users in the license management section of the website. Activations where the user hasn't logged in previously will be shown as anonymous.

For more information about managing your licenses, see Managing your Redgate licenses.

Identified users

Redgate Sql Prompt Pro

When end users have activated products with a Redgate ID, you'll be able to see their email addresses.

Not all products currently support activation with a Redgate ID, but we're working on adding support across the product range.

Anonymous claims

Because we don't know who users are if they haven't signed in with with a Redgate ID, we can't show identified users for all activations. Historical activations where a Redgate ID has not been used will be shown as anonymous.

However, if end users activate again using a Redgate ID, they will then be shown as identified users for the products they are using.

Finding your serial number

When you purchase a product, you can view your serial numbers at red-gate.com/myserialnumbers. You'll need to log in with the email address and password you provided when you purchased the product. Each time a serial number is used by a new user to activate a product, one license will be claimed.

For information about how to activate, see Activating.

For more information about managing your licenses, see Managing your Redgate licenses.

If you need to reinstall products on the same computer (e.g. after installing a new operating system), you can reactivate them using the same serial number. This doesn't affect the number of available licenses for the serial number. For information about moving a license to a different computer, see Moving a product license to a different computer.

Bundles and suites

If you've purchased a bundle or suite of products, your serial number will activate all the products in the bundle or suite.

If you deactivate a bundle or suite serial number, all products using that serial number will be deactivated.

For information on which products are included in a bundle, see Bundle history.

Redgate Sql Prompt

Changing the serial number used to activate a product

See Activating - Changing the serial number used to activate a product.

Moving a product license to a different computer

Redgate Sql Prompt Styles

See Deactivating - Moving a product license to a different computer.

Redgate Sql Server Prompt

Didn't find what you were looking for?