Comments
Sort by recent activity
RobertZ said:
For me this was solved by downloading the SQL Toolbelt Essentials installer from the RedGate website to update all packages. SQL Prompt itself did not need updating, but the overall Toolbelt update did resolve my issue with Prompt.
Thanks for this. This resolved it for me too after trying the other posted suggestions. Downloaded toolbelt essentials installer from: https://www.red-gate.com/products/sql-toolbelt-essentials/entrypage/latest-essentials Then updated the products that were flagged with updates (ignored any which would have triggered new trials). Working again now thankfully! / comments
RobertZ said:
For me this was solved by downloading the SQL Toolbelt Essentials installer from the RedGate website to update all packages. SQL Prompt itself did not need updating, but the ove...
Hi @Alex B, I've just updated to the latest versions for both and the problem still exists: SSMS: v18.0 (15.0.18118.0) SQL Prompt: 9.5.3.9640 Here's a gif of the issue if that helps: https://imgur.com/a/oVqYL45? I've been working around it for a while now so it's not a big deal. I realise another solution is to not press End so quickly and you'd think after a few months I would have gotten used to that! [image] / comments
Hi @Alex B,I've just updated to the latest versions for both and the problem still exists:SSMS: v18.0 (15.0.18118.0)SQL Prompt: 9.5.3.9640Here's a gif of the issue if that helps:https://imgur....
Hi @Alex B, Does that mean you were unable to reproduce the error by just pressing "End" while waiting for the operation? In my opinion that's the bigger issue as it changes the behaviour of End - which I instinctively press to un-highlight the text and get the cursor to the end ready to continue typing. Appreciate it's not a high priority but thanks for looking into this! Cheers, Tony / comments
Hi @Alex B,Does that mean you were unable to reproduce the error by just pressing "End" while waiting for the operation?In my opinion that's the bigger issue as it changes the behaviour of End - wh...
Was able to download the latest version and the issue seems to be resolved!
Thanks for the help @Mike U @Tianjiao_Li / comments
Was able to download the latest version and the issue seems to be resolved!
Thanks for the help @Mike U @Tianjiao_Li
Hi @Tianjiao_Li
Thanks for your reply.
My SQL Source Control is Version 6.0.2.6908. There are no updates available through the application and the same version is offered through the initial URL I was provided to download the tool.
We backed up and restored the DB to a new server and added source control. I was able to commit our most recent changes, but after this the error started again.
The script is in my original message.
Thanks,
Tony / comments
Hi @Tianjiao_Li
Thanks for your reply.
My SQL Source Control is Version 6.0.2.6908. There are no updates available through the application and the same version is offered through the initial URL I ...
tonywaddle said:
Colleague of mine is also having this issue, can't seem to correct it.
Managed to fix it by disabling the index, then apply latest changes again from Source Control. / comments
tonywaddle said:
Colleague of mine is also having this issue, can't seem to correct it.
Managed to fix it by disabling the index, then apply latest changes again from Source Control.
Colleague of mine is also having this issue, can't seem to correct it. / comments
Colleague of mine is also having this issue, can't seem to correct it.
Thanks Aaron - the new formatting system seems to have fixed both issues, but I've noticed a slightly different issue with it.
If a SQL statement has X number of spaces before it, for instance: " select 123", highlighting the SQL statement and applying the formatting will result in the text being highlighted X number of characters in.
So if there are three spaces before the statement, I will only have "ect 123" highlighted after applying the formatting. The same is true if there is tab indentation at the start of the string, but each tab will result in one character not highlighted.
This is only related to formatting highlighted text, and only occurs if you don't also highlight the leading spaces. In my scenario I use the end / shift-home shortcuts to highlight the text so the leading spaces are not highlighted. Not a big issue - obviously I can just press shift-home twice to get the complete line, just wanted to bring it to your attention.
Thanks,
Tony / comments
Thanks Aaron - the new formatting system seems to have fixed both issues, but I've noticed a slightly different issue with it.
If a SQL statement has X number of spaces before it, for instance: " ...
Thanks for the quick response Aaron.
There's another issue that may be related. If I highlight a long SQL statement that exists on one line (i.e. dynamic SQL string) only a portion of the SQL statement will remain highlighted after applying SQL Prompt's formatting.
For instance the output of the query below is 100 SQL statements in one long string (no line breaks). Formatting this results in 100 lines of code, however after formatting I only have halfway through line 86 selected. I think the intended behaviour would be for the entire statement to remain selected. DECLARE @DynSQL VARCHAR(MAX);
SELECT @DynSQL = ISNULL(@DynSQL + ';', '')
+ 'select 123'
FROM (SELECT TOP 100 *
FROM sys.objects
) a;
SELECT @DynSQL;
Thanks,
Tony / comments
Thanks for the quick response Aaron.
There's another issue that may be related. If I highlight a long SQL statement that exists on one line (i.e. dynamic SQL string) only a portion of the SQL state...
Hi Aaron,
Works perfect, thanks again! / comments
Hi Aaron,
Works perfect, thanks again!