Comments
Sort by recent activity
Hello Ram Kumar, Thanks for reaching out to Redgate Support, sorry to hear you got stuck with your Flyway project. In this case, could you let me know what kind of Database you are working with? I ask as some Database types should automatically rollback any changes performed mid migration when a migration fails, however other still do not. In either case, when the migration initially failed, you may have had to run the undo migration to reintroduce the name column which was dropped. (assuming you have undo migrations being generated) Once the repair was run, the flyway_schema_history table no longer knows about the failed migration and then the subsequent migration fails as you said. Best Regards, Christian Perez Product Support Engineer / comments
Official comment
Hello Ram Kumar, Thanks for reaching out to Redgate Support, sorry to hear you got stuck with your Flyway project. In this case, could you let me know what kind of Database you are working with? I ...
Hi Shelly, Thanks for reaching out to Redgate Support. Sorry to hear you are having an unexpected behavior showing up in your SQL Data Compare Application. In this case, I would like to replicate this behavior if possible so we can get this corrected, would you be able to share a few details with me? Version of SQL Data Compare installed Schema-Only Creation Script of Table that is showing 0's as Null. (If multiple let me know) Screenshot of the behavior I will then use a data generation tool on my end to try and mimic your data and this behavior. If you prefer to provide a full backup, I can generate a file request link for you. / comments
Official comment
Hi Shelly,Thanks for reaching out to Redgate Support. Sorry to hear you are having an unexpected behavior showing up in your SQL Data Compare Application. In this case, I would like to replicate th...
Hi ABI, Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with Descriptions on your Stored Procedures. In this case, I am curious if the description was actually added but is just not visible when executing the stored procedure. Could I have you try the below please:
In SSMS, navigate to the stored procedure in Object Explorer.
Right-click on the stored procedure and select Properties.
Go to the Extended Properties tab to view the description.
Are you seeing the description listed in the Extended Properties of your SP? / comments
Official comment
Hi ABI,Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with Descriptions on your Stored Procedures. In this case, I am curious if the description was actual...
Hi Daniel, Thanks for reaching out to Redgate Support regarding your SQL History concern. You are correct that this is present in previous versions as it is by design, see here some details on case sensitivity from our documentation https://documentation.red-gate.com/sp/ssms-tab-management/sql-history/searching-sql-history Why am I not getting the results I expect? Casing of both the words you are searching with and the query text you are searching for can have an effect on the results. To give the likeliest optimal results, compound words are broken up when searching. To do this, capital letters are treated as a word boundary. For example, if the table CustomerOrders appears in a query, this will be broken into Customer, Orders and CustomerOrders when searching. Searching for any of these will get a result. If the CustomerOrders table was defined as Customerorders instead, searching for customer or orders will not find it. The same word boundary logic is applied for the text being used in the search. If you don't find what you expect to, try to change the search text slightly by lower casing it and splitting words apart. That being said, if you would like us to add a feature to toggle case sensitivity for search results, I would recommend submitting an entry to our SQL Prompt User Voice forum so other Prompt users can vote on it and then possibly be implemented by development. https://redgate.uservoice.com/forums/94413-sql-prompt / comments
Official comment
Hi Daniel, Thanks for reaching out to Redgate Support regarding your SQL History concern. You are correct that this is present in previous versions as it is by design, see here some details on case...
Hi Dwaine, Thanks for reaching out to Redgate Software and sorry to hear you are having some SQL Prompt issues after upgrading. In this case, could I kindly request that you include your SQL Prompt logs for review here? Additionally, I am curious if you would be willing to uninstall and reinstall the version prior to 10.16.3 and see if this issue goes away. If there are any snippets or information you want to backup I believe the path is in Appdata/local/redgate/SQLPrompt. You can find all publicly available versions of Prompt Here: http://download.red-gate.com/checkforupdates/SQLPrompt/ / comments
Official comment
Hi Dwaine,Thanks for reaching out to Redgate Software and sorry to hear you are having some SQL Prompt issues after upgrading. In this case, could I kindly request that you include your SQL Prompt ...