Comments
Sort by recent activity
Hi Pgmaigd, Hope this finds you well, thanks for reaching out to Redgate Software with your feature request. The best place for you to submit this idea would be on our User Voice Forum which I am including below, specifically under the Toolbelt Essential forum as that would house Multi Script (Which I believe you are talking about, if not please correct me). Here is the link to the correct page: https://redgate.uservoice.com/forums/936348-sql-toolbelt-essentials Cheers, Product Support / comments
Hi Pgmaigd,Hope this finds you well, thanks for reaching out to Redgate Software with your feature request. The best place for you to submit this idea would be on our User Voice Forum which I am in...
Hi SwePeso, Sorry to hear you are having some issues with SQL Compare when utilizing Visual Studio 2022, I was able to locate some similar errors in other tickets when searching for microsoft.data.sqlclient.sni.x64.dll and Visual Studio 2022 and while for a different product, users had success utilizing Visual Studio version 17.5.0 and older so I am curious what version of Visual Studio you are currently using. Additionally, do you have any event viewer errors whenever this occurs? Could you possibly include the stack trace here for comparison? / comments
Hi SwePeso,Sorry to hear you are having some issues with SQL Compare when utilizing Visual Studio 2022, I was able to locate some similar errors in other tickets when searching for microsoft.data.s...
Hi Caladin, Thanks for reaching out to Redgate Support regarding you ANTS Visual Studio Integration inquiry. Unfortunately, there are not plans in the works to support Integrations with Visual Studio 2022, this particular integration is one of our least used so it is at the bottom of the priority list for development. That being said, I am not aware that development work has been deprecated for ANTs so this could be something that gets worked on in the future. / comments
Hi Caladin,Thanks for reaching out to Redgate Support regarding you ANTS Visual Studio Integration inquiry.Unfortunately, there are not plans in the works to support Integrations with Visual Studio...
Hey Sean, Thanks for reaching out to Redgate with this information and sorry to hear that you are having some problems with email alerts in Redgate Monitor. I was able to locate a User Voice entry (User Voice is a forum we provide to customers to raise enhancement requests with our products) for this exact request in Redgate Monitor to be implemented. I am including the link below so you can also vote on this topic to be implemented. https://sqlmonitor.uservoice.com/forums/91743-suggestions?query=plain text That being said, in the meantime you may have to use a different solution for your alerting if emails are no longer an option. I am including our documentation on the different methods we currently support for alerting below which includes:
email
Slack Notifications
SNMP Traps
Webhooks
Scripts
You may be able to use the scripting option to trigger a plain text email be sent out when an alert is triggered, but this would not be something Redgate Support could assist you in writing. https://documentation.red-gate.com/monitor/setting-up-script-notifications-239668102.html / comments
Hey Sean,Thanks for reaching out to Redgate with this information and sorry to hear that you are having some problems with email alerts in Redgate Monitor. I was able to locate a User Voice entry (...
Hello Stone, Apologies on the delay, Yes, the explanation makes sense. I installed this version of SQL Data Compare locally in my environment, created two system-versioned tables named Department and filled them both with 5 identical rows of data. My comparison in SQL Data Compare was accurate without any mismatches or errant data being show. Afterwards I added 2 additional rows to only one of the tables but they continue to show up nominally on my end. [image] Are you saying that the Test Database has 17 rows of data and the Production Database has 11 rows of data and when the comparison is performed you cannot see the differences? Would you be able to share your logs from SQL Data Compare? / comments
Hello Stone,Apologies on the delay, Yes, the explanation makes sense. I installed this version of SQL Data Compare locally in my environment, created two system-versioned tables named Department an...
Hi Stone, Sorry to hear you are having issues with system-versioned tables in SQL Data Compare. System Versioned tables should be supported, could you confirm which version of SQL Data Compare you currently have installed? Additionally, do you have a screenshot or example of the results being incorrect, I will need some more context in order to troubleshoot locally in my environment. Best Regards, Redgate Support / comments
Hi Stone,Sorry to hear you are having issues with system-versioned tables in SQL Data Compare. System Versioned tables should be supported, could you confirm which version of SQL Data Compare you c...
Hi Jgannon, Thanks for reaching out to Redgate with your multi-script automation request. The problem in this case is that SQL Multi-script does not have an API or Command Line inteface that can be used to kick off the job in an automated way. A SQL Monitor custom metric maybe a better solution for you. If you'd like to investigate other options then raise a support ticket with support@red-gate.com You might be able to rig up something to meet your needs using the windows scheduler and the sqlcmd command line utility See, http://msdn.microsoft.com/en-us/library/ms170207.aspx. But this isn't something that we could support you with. / comments
Hi Jgannon,Thanks for reaching out to Redgate with your multi-script automation request. The problem in this case is that SQL Multi-script does not have an API or Command Line inteface that can be ...
Great News, glad to hear it. / comments
Great News, glad to hear it.
Hi Kostas_Ch, Thanks for reaching out to Redgate Software with your SQL Prompt inquiry, with respect to being able to remove schemas from intellisense auto-fill I was able to find the following entry which should answer your question: = = = = = The suggestions box is automatically widened to allow space for the schema names, shown in grey to the left of the suggestions: [image] To hide the list of schema (owner) names, click the left arrow [image]
The arrows only affect how object names are displayed in the suggestions box. The schema (owner) name is only inserted into your code when Qualify object names with owner name is selected on the Inserted Code > Qualification options page.
= = = =
Could you try disabling the 'Qualify object names with owner name' Prompt setting and seeing if you have any change in behavior?
https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/inserting-suggestions-into-your-code#Insertingsuggestionsintoyourcode-DisplayingschemanamesDisplayingschema(owner)names
/ comments
Hi Kostas_Ch,Thanks for reaching out to Redgate Software with your SQL Prompt inquiry, with respect to being able to remove schemas from intellisense auto-fill I was able to find the following entr...
Hello Schachar, Thanks for reaching out to Redgate Software regarding your SQL Prompt inquiry. I believe you may have some luck using SQL Prompt's Code Completion and Ranked Suggestion features in this case. I am going to include the link to our documentation on both topics so you can review. Ranked Suggestion: https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/inserting-suggestions-into-your-code#Insertingsuggestionsintoyourcode-RankedSuggestions Code Completion: https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/using-and-configuring-code-completion-suggestions-quick-ref Lastly, an alternative solution you may wish to consider is utilizing a snippet in your environment to save a pre-written join clause as an alias like join1 and then you can just use the snippet to auto-write the join query. https://documentation.red-gate.com/sp/sql-code-snippets Hopefully the above gives you some ammunition to determine which solution is best for you. But let me know if you have any follow up concerns. / comments
Hello Schachar,Thanks for reaching out to Redgate Software regarding your SQL Prompt inquiry. I believe you may have some luck using SQL Prompt's Code Completion and Ranked Suggestion features in t...