Activity overview
Latest activity by cperez
Hi @dann , Thanks for reaching out to Redgate Support. That is a peculiar behavior you are reporting, I just installed version 10.16.5.15563 and used SSMS 20 and this behavior did not replicate for me, StatisticsInfo pulled up 0 results in my environment and then query picked up many results. Has this behavior replicated for you in the past for any other search terms or just StatisticsInfo? / comments
Official comment
Hi @dann , Thanks for reaching out to Redgate Support. That is a peculiar behavior you are reporting, I just installed version 10.16.5.15563 and used SSMS 20 and this behavior did not replicate for...
Good Morning @..., Thanks for reaching out to Redgate Support regarding your Monitor question. I am including a screenshot of what I see when I search for CPU using our SQL Search Tool, if you also have that product, feel free to do the same. It does appear that the tables are broken down by Server Type. (Amazon, Azure, SQL, Oracle) [image] / comments
Good Morning @..., Thanks for reaching out to Redgate Support regarding your Monitor question. I am including a screenshot of what I see when I search for CPU using our SQL Search Tool, if you also...
Hi @jsreynolds1, Thanks for reporting this issue to Redgate Support, I have tested this some and I think I may have this issue replicated, however, could I kindly ask that you provide the above query not as a screenshot but as actual text, I would like to test on your specific query and ensure the behavior is the same. Cheers, Product Support / comments
Hi @jsreynolds1,Thanks for reporting this issue to Redgate Support, I have tested this some and I think I may have this issue replicated, however, could I kindly ask that you provide the above quer...
Good Morning @FTP2It, Thanks for reaching out to Redgate Support. Glad that the issue is now resolved on your end. That "System.NullReferenceException: Object reference not set to an instance of an object." historically has a number of different causes, so we would ideally need a copy of your Monitor Logs to see if any other errors are present. If you see the issue pick back up in the future, I would recommend collecting said logs and then attaching them here and we can see if we can determine if there is a root cause here of if this was just an intirmittant behavior. / comments
Good Morning @FTP2It,Thanks for reaching out to Redgate Support. Glad that the issue is now resolved on your end. That "System.NullReferenceException: Object reference not set to an instance of an ...
Hi Josh, Thanks for reaching out to Redgate Support. So with respect to the RedgateDatabaseInfo.xml file, after doing a preliminary search through our documentation, I do not see a manner in which you can change the default location of the .xml file. Here is what I found: = = = = = = = = https://documentation.red-gate.com/sc/using-the-command-line/using-xml-to-specify-command-line-arguments Scripts folder database information file When you create a scripts folder, an XML file containing some basic details about the structure of the database is created. The file is called RedGateDatabaseInfo.xml and is stored in the main scripts folder at the top level. If the file does not exist when you run the comparison, SQL Compare creates it, using the default values. = = = = = = = = Additionally, checking through Flyway documentation, I do not see any CLI or parameters for editing the path. https://documentation.red-gate.com/flyway/reference/commands https://documentation.red-gate.com/flyway/reference/configuration / comments
Hi Josh,Thanks for reaching out to Redgate Support. So with respect to the RedgateDatabaseInfo.xml file, after doing a preliminary search through our documentation, I do not see a manner in which y...
Hi Sean, Link is in my previous message under Cheers, Product Support marked as SQLToolbeltEssentials.exe, can you not see the attachment by chance? / comments
Hi Sean,Link is in my previous message under Cheers, Product Support marked as SQLToolbeltEssentials.exe, can you not see the attachment by chance?
Hi Ozzie, For a list of priviliges SQL Prompt may need you can find that listed HERE. That being said the one I would double check first would be the VIEW ANY DEFINITION permission which will let you view all metadata in the SQL Server instance, you can then check withSELECT srvname, srvproduct, providername FROM master..sysservers to confirm if the permission is now set correctly. Check the above permissions and let me know if you already had them set correctly. / comments
Hi Ozzie,For a list of priviliges SQL Prompt may need you can find that listed HERE.That being said the one I would double check first would be the VIEW ANY DEFINITION permission which will let you...
Hi Ozzie, Thanks for the requested files, looking at the screenshot as well as the logs you provided I am seeing an interesting error for ds-sql-database.database.windows.net. I believe this is the same server in the screenshot you provided, could you confirm you do indeed have access to these servers and can load suggestions or is everything locked down for this server with respect to Prompt? [Warning] Failed to load server ds-sql-database.database.windows.net Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user token-identified principal / comments
Hi Ozzie, Thanks for the requested files, looking at the screenshot as well as the logs you provided I am seeing an interesting error for ds-sql-database.database.windows.net. I believe this is the...
Good Morning Sean, Thanks for reaching out to Redgate Software and sorry to hear you are having trouble with the toolbelt essentials installer. Thankfully, I believe this issue can be caused by a corrupted installer, could I have you try the latest installer instead? Link is included below, alternatively, you can also attempt running the MS .NET repair tool if the issue persists with the new installer. https://www.microsoft.com/en-gb/download/details.aspx?id=30135 Cheers, Product Support SQLToolbeltEssentials.exe
/ comments
Good Morning Sean,Thanks for reaching out to Redgate Software and sorry to hear you are having trouble with the toolbelt essentials installer. Thankfully, I believe this issue can be caused by a co...
Hi Ozzie, Thanks for reaching out to Redgate Support, sorry to hear you are having some issues with your SQL prompt install. Would you be able to share your SQL Prompt logs here so we can take a look for any errors? (SQL Prompt > Help > Locate Log Files) Also a screenshot of what you are seeing when the issue replicates would be helpful as well. Cheers, Product Support / comments
Hi Ozzie,Thanks for reaching out to Redgate Support, sorry to hear you are having some issues with your SQL prompt install. Would you be able to share your SQL Prompt logs here so we can take a loo...