Comments
Sort by recent activity
Hi there, Thank you for reaching out and I apologize that you are running into issues with SQL Prompt. From this page: https://documentation.red-gate.com/sp/sql-refactoring/refactoring-an-object-or-batch/finding-invalid-objects Objects are listed as invalid by SQL Prompt if they:
can't be compiled
can be compiled, but can't be executed For example, a stored procedure that references an object that no longer exists in the database is listed as invalid. WARNING: synonyms with not existing reference are not supported.
Thank you! David Kim Product Support Engineer
/ comments
Hi there,Thank you for reaching out and I apologize that you are running into issues with SQL Prompt.From this page: https://documentation.red-gate.com/sp/sql-refactoring/refactoring-an-object-or-b...
Hi there, Thank you for reaching out about SQL Prompt. For your questions: SQL Prompt does not have the feature to change the capitalization of both column names or schema names.
It currently only supports the capitalization of data types [image] For your second question, all the formatting abilities of SQL Prompt should be in the "Edit formatting styles" option. For CASE, WHEN, ELSE, END, it will be located here. [image] Sincerely, David Kim Product Support Engineer
/ comments
Hi there,Thank you for reaching out about SQL Prompt.For your questions:SQL Prompt does not have the feature to change the capitalization of both column names or schema names.
It currently only su...
Hi there, Thank you for reaching out and I apologize that you are running into issues with SQL Prompt. I apologize but can you clarify the issue again? Thank you! David Kim Product Support Engineer
/ comments
Hi there,Thank you for reaching out and I apologize that you are running into issues with SQL Prompt.I apologize but can you clarify the issue again?Thank you!David KimProduct Support Engineer
Hi there,
I raised this issue with the development team. Unfortunately they have decided to not take this bug on. I apologize for any inconvenience that this may cause.
Kind Regards,
David Kim
Product Support Engineer
/ comments
Hi there,
I raised this issue with the development team. Unfortunately they have decided to not take this bug on. I apologize for any inconvenience that this may cause.
Kind Regards,
David Kim
Pro...
Hi there, Thank you for the information. I still have not been able to recreate your issue on my end. If you try uninstalling SQL Prompt, does the issue still occur? This would help us isolate if it is an SSMS or SQL Prompt issue. Thank you! David Kim Product Support Engineer
/ comments
Hi there,Thank you for the information.I still have not been able to recreate your issue on my end.If you try uninstalling SQL Prompt, does the issue still occur? This would help us isolate if it i...
Hi there, Thank you for reaching out and I apologize that you are running into issues with SQL Prompt. I have been unable to recreate your issue on the latest version of SQL Prompt. What version of SSMS are you currently using? In addition, if possible, could you send a screen recording of recreating the issue? Thank you! David Kim Product Support Engineer
/ comments
Hi there,Thank you for reaching out and I apologize that you are running into issues with SQL Prompt.I have been unable to recreate your issue on the latest version of SQL Prompt. What version of S...
Hi there, I am glad to hear that you have fixed the issue. If you have any other questions, feel free to reach out! Kind Regards, David Kim Product Support Engineer
/ comments
Hi there,I am glad to hear that you have fixed the issue.If you have any other questions, feel free to reach out!Kind Regards,David KimProduct Support Engineer
Hi there, Thank you for reaching out and I apologize that you are running into issues with SQL Monitor. Can you make sure that you have properly copied the Webserver.Kestrel.Config file into the ProgramData folder while leaving the unedited, original copy in the ProgramFiles folder? In addition, can you please send over your Webserver.Kestrel.Config file to make sure that you have configured it properly? Thank you! David Kim, Product Support Engineer
/ comments
Hi there,Thank you for reaching out and I apologize that you are running into issues with SQL Monitor.Can you make sure that you have properly copied the Webserver.Kestrel.Config file into the Prog...
Hi there, I am glad to hear that you found the solution to your issue. "While there was no IIS installed on the server,
Window's http.sys kernel driver was active and felt responsible for all
https requests on the server. In our case this was because we had
installed the Windows Admin Center gateway on the same server as SQL
Monitor. To solve this I added a second IP to the server. The I limited http.sys to one of the IP addresses. In the Webserver.Kestrel.config I configured the other IP for SQL Monitor. After doing this the services starts and https for the site works." Sincerely, David Kim Product Support Engineer
/ comments
Hi there,I am glad to hear that you found the solution to your issue."While there was no IIS installed on the server,
Window's http.sys kernel driver was active and felt responsible for all
https...
Hi there, Thank you for reaching out and I apologize that you are running into issues with SQL Prompt. I have not been able to recreate your issue on my end. Can you provide some steps on how you are receiving the error? Thank you! David Kim Product Support Engineer
/ comments
Hi there,Thank you for reaching out and I apologize that you are running into issues with SQL Prompt.I have not been able to recreate your issue on my end. Can you provide some steps on how you are...