Comments
Sort by recent activity
Good Afternoon! Can you confirm what version of SQL Monitor that you're using? Also can you confirm if the instance showcasing the issue doesn't have a separate threshold setting versus what's setup for the alert at the All Servers Level? https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/configuring-alerts/customizing-the-alert-settings I bring this up because the settings for an alert on a specific instance will override what's set for the alert at the general level. Thanks!
/ comments
Good Afternoon!Can you confirm what version of SQL Monitor that you're using?Also can you confirm if the instance showcasing the issue doesn't have a separate threshold setting versus what's setup ...
Hello @CJMartin, Just wanted to update you that a new version of SQL Prompt has been released. Can you try installing the version below and let us know if it helps you out? Download Link: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.10.3.25844.exe
Thanks!
/ comments
Hello @CJMartin,Just wanted to update you that a new version of SQL Prompt has been released.Can you try installing the version below and let us know if it helps you out?Download Link: https://down...
Thanks for the update on your end. We have created a support ticket regarding your issue and will continue with aiding you on there for the time being. / comments
Thanks for the update on your end.We have created a support ticket regarding your issue and will continue with aiding you on there for the time being.
Good Afternoon! Thanks for your inquiry and sorry to hear about your issue with SQL Monitor. Can you confirm what version of SQL Monitor that you're using? It would be helpful to know as later version do have better logging for your particular issue.
/ comments
Good Afternoon!Thanks for your inquiry and sorry to hear about your issue with SQL Monitor.Can you confirm what version of SQL Monitor that you're using? It would be helpful to know as later versio...
Good Afternoon! Thanks for your inquiry and sorry to hear about your issue with SQL Change Automation. Can you try restarting SSMS on your end to see if that helps?
/ comments
Good Afternoon!Thanks for your inquiry and sorry to hear about your issue with SQL Change Automation.Can you try restarting SSMS on your end to see if that helps?
Good Afternoon! First we would recommend creating a new fresh image via the SQL Clone Server. Afterwards you can just run the following powershell script manually to update all of the clones involved with the image: https://documentation.red-gate.com/clone/automation/powershell-worked-examples/refresh-all-clone-databases-to-use-an-updated-image Please let me know if you need anything else. Thanks!
/ comments
Good Afternoon!First we would recommend creating a new fresh image via the SQL Clone Server. Afterwards you can just run the following powershell script manually to update all of the clones involve...
Good Afternoon! Regex tends to be better at matching things versus not matching things. Given that, we believe that a negative lookahead would be the way to go. It would look something like which
will actually only match the first [ (which should cause the item to be included as there is a match) but it will only match that when that is NOT followed by dbo.].[Broadcast% (using the SQL wild card string to show what I mean rather than it actually being the percent sign) ^\[(?!dbo\]\.\[Broadcast.*) [image] The second one is similar just having the .* before and after ist: ^\[(?!dbo\]\.\[.*ist.*)
[image] Can you let me know if that helps you out? Thanks!
/ comments
Good Afternoon!Regex tends to be better at matching things versus not matching things. Given that, we believe that a negative lookahead would be the way to go.It would look something like which
wi...
Hello Bjorn, Thanks for the updates on your end. Can you let me know if using the Powershell CMDletsdid helped out with your issue? Also I would highly recommend creating a uservoice regarding this UI suggestions so that the developers can see the demand for such a feature: https://sqlmonitor.uservoice.com/forums/91743-suggestions
Thanks!
/ comments
Hello Bjorn,Thanks for the updates on your end.Can you let me know if using the Powershell CMDletsdid helped out with your issue?Also I would highly recommend creating a uservoice regarding this U...
Hello Björn, Thanks for your inquiry with SQL Monitor. In your case, I would recommend using a powershell script in order to manage all of these alert configurations: https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/configuring-alerts/bulk-configuration-of-alerts-using-powershell This way you can theoretically just run one script to get this configured rather than having to go through the GUI interface over and over again. Please let me know if you have any other questions or concerns on this. Thanks! / comments
Hello Björn,Thanks for your inquiry with SQL Monitor.In your case, I would recommend using a powershell script in order to manage all of these alert configurations:https://documentation.red-gate.co...
Hello Torsten, Thanks for the update on your end. So I made sure to have the same versions of both SSMS and SQL Prompt, and formatted the query using your same style and settings. Unfortunately, I still don't see the same issue. Can you let me know what version of SQL Server that you're running this against just in case that plays a factor? Thanks!
/ comments
Hello Torsten,Thanks for the update on your end.So I made sure to have the same versions of both SSMS and SQL Prompt, and formatted the query using your same style and settings. Unfortunately, I st...