Comments
Sort by recent activity
Good Afternoon Stefan, Thanks for reaching out to Redgate Support regarding your Prompt question and for providing the exact version you are utilizing. I am not aware of any limitation for Prompt providing suggestions for placeholders however placeholders are typically utilized for column names rather than table names as you are using in your example unless you are using dynamic sql. Could you share the TSQL used for declaring @Tabellen so I can mimic the same conditions from your environment? / comments
Good Afternoon Stefan,Thanks for reaching out to Redgate Support regarding your Prompt question and for providing the exact version you are utilizing. I am not aware of any limitation for Prompt pr...
Hi jsreynolds, Thanks for reaching out to Redgate Support. I suspect that intellisense may be underlining those statements. If you go to Open Tools>Options>Text Editor>Transact-SQL>Intellisense. Is Intellisense disabled here? You can see a sub-setting 'Underline error' that's the option which I believe is causing the issue for you. If you disable this and close and reopen SSMS are you still seeing the same behavior? / comments
Hi jsreynolds,Thanks for reaching out to Redgate Support.I suspect that intellisense may be underlining those statements. If you go to Open Tools>Options>Text Editor>Transact-SQL>Intellisense. Is I...
Good Afternoon Wayne Francis, Thanks for reaching out to Redgate with your Formatting Style inquiry. In order for me to get an exact 1:1 of what you are experiencing, can you let me know which version of SQL Prompt you are utilizing? Additionally, could I kindly request that you provide me with your formatting style that you are testing with? You can locate your custom styles in the following directory C:\Users\<YOURUSER>\AppData\Local\Red Gate\SQL Prompt 10\Styles and attach it here. I can then test this locally and see if I can provide you with a solution that fits your style. / comments
Good Afternoon Wayne Francis,Thanks for reaching out to Redgate with your Formatting Style inquiry. In order for me to get an exact 1:1 of what you are experiencing, can you let me know which versi...
Hi mbellas, Thanks for reaching out to Redgate Support. Support for version 20 of SSMS was added in March of this year for SQL Prompt. (Version 10.14.11.7894) Could I have you confirm the version of Prompt that you have installed by clicking on SQL Prompt > Help > About SQL Prompt in SSMS? Additionally, I would like to gather your SQL Prompt log to confirm the connection errors you are mentioning. (File Link HERE) Could you select SQL Prompt > Help > Enable Verbose Logging and then replicate the connection error and afterwards select SQL Prompt > Help > Locate Log Files and attach them to the File Link I left above? Best Regards, Christian Perez Product Support Engineer / comments
Hi mbellas,Thanks for reaching out to Redgate Support. Support for version 20 of SSMS was added in March of this year for SQL Prompt. (Version 10.14.11.7894) Could I have you confirm the version of...
Good Morning Mbourgon2, Thanks for reaching out to Redgate Support with your SQL Prompt concern. I believe you are referring to having to select a Redgate Platform team when sharing Snippets using the Snippets Manager in SQL Prompt? I was able to confirm this behavior locally, and that is to be expected, Redgate Platform uses the selected team to synchronize your shared Snippets with other members of that team. If you are wanting SQL Prompt to automatically detect there is only 1 team to choose from and select that team automatically, I would recommend you submit this as an enhancement request on our User Voice website for SQL Prompt so that it may be considered in future releases of the product. I am including a link to that webpage below. https://redgate.uservoice.com/forums/94413-sql-prompt Hopefully this answers your question, please let me know if there is anything else. / comments
Good Morning Mbourgon2,Thanks for reaching out to Redgate Support with your SQL Prompt concern. I believe you are referring to having to select a Redgate Platform team when sharing Snippets using ...
Good Afternoon DevPS, Thanks for reaching out regarding your Flyway Java API compatibility concerns. With respect to Flyway Java API, I can confirm that at this time JDK 21 is not supported, only up to JDK 17. I am going to include some documentation where I found this information. With respect to Derby compatibility, it is officially supported up to version 10.15, and I will also include the pertinent documentation for that as well below. Flyway Java API Compatability https://documentation.red-gate.com/flyway/flyway-cli-and-api/usage/api-java Derby Supported Database https://documentation.red-gate.com/flyway/flyway-cli-and-api/supported-databases/derby Please let me know if you have any additional questions. Best Regards, Christian Perez Product Support Engineer / comments
Good Afternoon DevPS,Thanks for reaching out regarding your Flyway Java API compatibility concerns. With respect to Flyway Java API, I can confirm that at this time JDK 21 is not supported, only up...
Thanks for following up Wingdog, With respect to being able to change Alert Settings system-wide, we do have Powershell API's you can utilize with SQL Monitor to change a variety of settings. I am going to direct you to our documentation on Powershell APIs which will point you towards our example scripts and guide you through the setup process. Setting up the Powershell API https://documentation.red-gate.com/sm/api/powershell-api Example Scripts https://documentation.red-gate.com/sm/api/powershell-api/example-scripts Best Regards, Christian Perez / comments
Thanks for following up Wingdog,With respect to being able to change Alert Settings system-wide, we do have Powershell API's you can utilize with SQL Monitor to change a variety of settings. I am g...
Good Afternoon, I understand you are attempting to exclude system databases from your SQL Monitor environment. With respect to alarms, you should be able to click on Configuration > Alert Settings from the SQL Monitor UI and drill down to the database level in order to suppress all alerting from those databases. Please see the image below: [image] With respect to SQL Monitor Reports and checkups, could you possibly elaborate on what you are trying to achieve? What are you referring to when you say checkups? Best Regards, Christian Perez / comments
Good Afternoon,I understand you are attempting to exclude system databases from your SQL Monitor environment. With respect to alarms, you should be able to click on Configuration > Alert Settings f...
Thanks for the update Adam, I was able to test this locally and at this time, it does not appear you can right align on the INNER or LEFT portion of the JOIN clause using a custom formatting style. Fortunately, I was able to find a vote for this issue currently being held on our SQL Prompt feature suggestion page which I will link below. https://redgate.uservoice.com/forums/94413-sql-prompt/filters/new?query=Right align on INNER JOIN I encourage you to vote on this issue so it can possibly be introduced in a future version. Cheers, Christian Perez / comments
Thanks for the update Adam,I was able to test this locally and at this time, it does not appear you can right align on the INNER or LEFT portion of the JOIN clause using a custom formatting style. ...
Good Afternoon, In order to better assist you, could you confirm which version of SQL Prompt you are utilizing? / comments
Good Afternoon,In order to better assist you, could you confirm which version of SQL Prompt you are utilizing?