Search
-
SQLprompt not working with SSMS 19. All other tools in sqltoolbelt working
The SQLPrompt not working in SSMS 19.x onwards. I use other software in SQLToolbelt and works fine. The log shows its already installed but I have verified the RedGate install directory and add or remove programs, the prompt is not available. Tried installing using SQLtoolbet exe as well as standalone SQL prompt exe. Any… -
Re: SQL Change Automation: releast to Azure SQL DB with AAD authentication only
Hello, Guys. I found this issue and I think it's related to my case. But only difference is I'm using Octopus deploy. Is there any documentation on how to implement this kind of setup in Octopus deploy? Hope to hear from you soon! Btw, here's the error I got after shifting to AAD auth. Sqlcmd: invalid argument… -
Handle out of order changes to static data
We have a table that we use to store the current version of an application. A simplified version of it can be thought of as a primary key (auto-incrementing) and a string with the application version number. We want to treat this data as Flyway static data so that the version number is automatically updated as migration… -
Redgate is making an Index recommendation - Confused as to what the index needs to be
Hi, I'm using monitoring to keep an eye on overall health of our SQL servers (3). But generally the applications that are being monitored are off the shelf and not something we've built in-house. Today I've been monitoring a new application that the company has gone live with and Redgate Monitor and it has recommended a… -
Collapse CASE statements
The "Collapse CASE statements shorter than N characters" option appears to conflict with the Lists --> List items --> "Place first item on new line" option, when the first expression in a SELECT statement is a CASE expression. When I have "Place first item on new line" set to Always and "Collapse CASE statements"… -
MySQL Data Compare bug report
I have sent an email to your company but never heard and answer so trying here ... I need to get missing data out of the db. Also this is just going to migrate it over and keep the new stuff right ? here is the error Bug report generated at 3/13/2012 4:08:17 AM Program version 1.0.0.351 System.Exception: When deploying… -
Unable to get profiler to connect to IIS - ASP.NET on webserver
Getting a System.IO.IOException: Pipe write operation failed with code 0xe8 Have disabled all antivirus on webserver. it feels like a permissions issue or maybe some windows feature is not installed? any suggestions would be appreciated! here is the stack: 07 Aug 2023 12:33:03.479 [Profiler pipe monitor] INFO… -
Re: Error with Source Control - Unable to case object of type 'RedGate.SQLCompare...'
-
Have you run into issues with Microsoft SmartScreen blocking access to license a Redgate product?
I rolled out SQL Prompt to several users at my company. One user's Red-Gate login for license activation was blocked by SmartScreen. Any connection to http://localhost:22223 was blocked. I disabled SmartScreen and the activation was successful. I enabled SmartScreen again after activation of the product. Hopefully it will… -
SQL Prompt not working on SQL 2005 after Update to 10.14.6.5992
Here is the error log. Tried reinstalling already. Used to work fine on 10.14.1 2024-01-30 16:16:15.450 -08:00 [Information] [servername].[master] loading skipped2024-01-30 16:16:51.790 -08:00 [Information] Chosen server capabilities "Sql2005"2024-01-30 16:16:51.799 -08:00 [Information] Resource Pools suggestions are not…
>5990 results