User profile for Michael Clark

Hi @sivanagamahesh, Sorry to hear your are having difficulties. Would it be possible to tell us a little more about your problem? Are you using SQL Prompt? Best wishes, Michael / comments

Hi @sivanagamahesh, Sorry to hear your are having difficulties. Would it be possible to tell us a little more about your problem? Are you using SQL Prompt? Best wishes, Michael

0 votes

Hi @PDinCA, Thanks for getting in touch. We're really sorry to hear that out of memory exceptions stopped you using code analysis. We are trying to improve code analysis and your feedback is really valuable. I can see from the log file you uploaded that you are using SQL Prompt 9.0.1.3179. That version already had some improvements to issues around out of memory, however it doesn't look like it was enough to handle your scripts/connections. Do you have other SSMS plugins installed? How large are your tabs? What is the size of C:\Users\<USERNAME>\AppData\Local\Red Gate\SQL Prompt 9\SavedTabs.db? Best, Michael / comments

Hi @PDinCA, Thanks for getting in touch. We're really sorry to hear that out of memory exceptions stopped you using code analysis. We are trying to improve code analysis and your feedback is really...

0 votes

Hi @bmjohnson82, Thanks very much for cross-posting this message to the forum. As mentioned before, we can see your error appearing on our error reporting system here (not public) so it's certainly unexpected behaviour. I will ask our support team to create a ticket for you to begin the investigation process. Best, Michael / comments

Hi @bmjohnson82, Thanks very much for cross-posting this message to the forum. As mentioned before, we can see your error appearing on our error reporting system here (not public) so it's certainly...

0 votes

Hi @mkane / @Jovanny , I think this issue may be related to this thread. https://forum.red-gate.com/discussion/82047/sql-prompt-core-suggestions-for-ssdt-projects#latest What version of SQL Prompt are you using? Is it SQL Prompt Core or SQL Prompt Pro? You can find the version in the menu SQL Prompt -> Help -> About SQL Prompt We changed behaviour in the latest release so that we do not override SSDT autocomplete if you have a SSDT Database Project in your solution. Best wishes, Michael / comments

Hi @mkane / @Jovanny , I think this issue may be related to this thread.https://forum.red-gate.com/discussion/82047/sql-prompt-core-suggestions-for-ssdt-projects#latest What version of SQL Prompt a...

0 votes

Hi @Jovanny, We disable SQL Prompt for SSDT because we do not yet support offline suggestions from SQL files in Visual Studio/SSDT Projects which was causing users to lose capabilities provided by the Native Intellisense. There's not currently a workaround except using SQL Prompt Pro, but we would like to understand a bit more about how you are trying to use SQL Prompt Core. Would it be possible to ask a little about how you are using SQL Prompt with the SSDT project? Are you using a connected query window while in a database project for instance? What do you prefer about SQL Prompt's autocomplete? Best, Michael / comments

Hi @Jovanny, We disable SQL Prompt for SSDT because we do not yet support offline suggestions from SQL files in Visual Studio/SSDT Projects which was causing users to lose capabilities provided by ...

0 votes

Hi @torsten.strauss, Thanks for reporting. Is this another issue after updating or was it there before? Would it be possible to create a code block for your expected after format? Best wishes, Michael / comments

Hi @torsten.strauss, Thanks for reporting. Is this another issue after updating or was it there before? Would it be possible to create a code block for your expected after format? Best wishes, Michael

0 votes

Hi @torsten.strauss, Thanks for reporting! Would it be possible to paste your actual/expected output in a code block? Are you expecting no spaces there or should they be aligned? Thanks, Michael / comments

Hi @torsten.strauss, Thanks for reporting! Would it be possible to paste your actual/expected output in a code block? Are you expecting no spaces there or should they be aligned? Thanks, Michael

0 votes

Hi @torsten.strauss, Sorry to hear that the alignment seems to be wrong after updating. Would it be possible to paste your expected versus actual examples in a code block on here? We will then take those examples and try to reproduce them. Best wishes, Michael / comments

Hi @torsten.strauss, Sorry to hear that the alignment seems to be wrong after updating. Would it be possible to paste your expected versus actual examples in a code block on here? We will then take...

0 votes

Hi @torsten.strauss, Sorry to hear that this isn't working well for you after the update. We changed the tab behaviour so that statements are indented with tabs in more circumstances. Are there any other statements that you have noticed that are exhibiting the same behaviour? We have logged this bug as SP-6679 Best, Michael / comments

Hi @torsten.strauss, Sorry to hear that this isn't working well for you after the update. We changed the tab behaviour so that statements are indented with tabs in more circumstances. Are there any...

0 votes

Hi @gbritton, Thanks for reporting that issue. As you just created the stored procedure, you will need to refresh your suggestions via the menu: SQL Prompt -> Refresh suggestions If you would like it to auto-refresh, would it be possible to vote on this UserVoice suggestion: https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/2106127-automatic-suggestion-refresh Best, Michael / comments

Hi @gbritton, Thanks for reporting that issue. As you just created the stored procedure, you will need to refresh your suggestions via the menu: SQL Prompt -> Refresh suggestions If you would like ...

0 votes

How can we help you today?

Michael Clark

Comments