Comments
Sort by recent activity
Hi dennyk,
Thanks for reporting. Does the icon issue go away when you select the line again? Or can you cause it to happen any time you select the line on the second monitor?
We do have a known issue where moving the SQL Prompt window leaves the icon in the same position.
Best wishes,
Michael Clark
Technical Lead, SQL Prompt / comments
Hi dennyk,
Thanks for reporting. Does the icon issue go away when you select the line again? Or can you cause it to happen any time you select the line on the second monitor?
We do have a known iss...
Hi gsemel,
Thanks for reporting that issue -- sorry that we are no longer showing your triggers as invalid objects.
Would it be possible to confirm that using a Linked Server has caused Find Invalid Objects to stop working with your trigger?
Could you give us a little more information about how you are using Find Invalid Objects to maintain your database triggers?
Best wishes,
Michael Clark
Technical Lead, SQL Prompt / comments
Hi gsemel,
Thanks for reporting that issue -- sorry that we are no longer showing your triggers as invalid objects.
Would it be possible to confirm that using a Linked Server has caused Find Invali...
Hi Anw,
Sorry to hear that you are getting that error on multiple VS/SSMS versions.
When do you normally see it - is it on startup? Would it be possible to attach a screenshot?
Best wishes,
Michael Clark
Technical Lead, SQL Prompt / comments
Hi Anw,
Sorry to hear that you are getting that error on multiple VS/SSMS versions.
When do you normally see it - is it on startup? Would it be possible to attach a screenshot?
Best wishes,
Michael...
Hi GHauan,
We support the style you want as default with our new formatting styles.
You can turn these on by selecting "SQL Prompt > Options... > Labs > Experimental Features > Use new formatting styles"
Please let us know if you have any trouble [image]
Thanks,
Michael / comments
Hi GHauan,
We support the style you want as default with our new formatting styles.
You can turn these on by selecting "SQL Prompt > Options... > Labs > Experimental Features > Use new formatting s...
Hi GHauan,
Thanks for the suggestion. You can insert code tags on here to keep your text formatted.
Could I confirm you want to style your code like this? Are you using the new formatting options (enabled in experimental features)? SELECT *
FROM dbo.Anlegg
WHERE AnleggsId = 1
AND StartDate <= getdate()
AND StopDate IS NULL;
Best wishes,
Michael Clark
Technical Lead, SQL Prompt / comments
Hi GHauan,
Thanks for the suggestion. You can insert code tags on here to keep your text formatted.
Could I confirm you want to style your code like this? Are you using the new formatting options (...
Hi Josh,
Sorry to hear you are having trouble copying into the new window. Could I confirm that you started seeing this after upgrading?
What type of database are you trying to connect to? Are you using Azure or a local connection?
Best wishes,
Michael Clark
Technical Lead, SQL Prompt / comments
Hi Josh,
Sorry to hear you are having trouble copying into the new window. Could I confirm that you started seeing this after upgrading?
What type of database are you trying to connect to? Are you ...
Hi Dnv,
Thanks for reporting the lack of column suggestions in that scenario. I have reproduced this in SQL Server 2014 with the latest version of SQL Prompt.
I have logged this as a bug under reference SP-6251 and we will get back in touch if we find a fix. [image]
Best wishes,
Michael Clark
Technical Lead, SQL Prompt / comments
Hi Dnv,
Thanks for reporting the lack of column suggestions in that scenario. I have reproduced this in SQL Server 2014 with the latest version of SQL Prompt.
I have logged this as a bug under refe...
Hi Kev,
Thanks for the suggestion. If I'm understanding correctly, you are suggesting that SELECT statements should be expandable in the Summarize Script feature so that you can see any subqueries in the tree.
At the moment we have basic SELECT statement handling in Summarize Script, we only show whether it is a SELECT FROM <table> or SELECT <expression>.
If you think this would be a useful feature, would it be possible to add the suggestion on our UserVoice page to allow other users to vote on it? https://redgate.uservoice.com/forums/94413-sql-prompt
Best wishes,
Michael Clark
Technical Lead, SQL Prompt / comments
Hi Kev,
Thanks for the suggestion. If I'm understanding correctly, you are suggesting that SELECT statements should be expandable in the Summarize Script feature so that you can see any subqueries ...
I have tested this on today's SSMS 17 and can confirm that the SQL Prompt installer does not pick up the additional SSMS version if you install the same version again. [image]
However uninstalling and reinstalling worked on SSMS 2017 as a workaround so it is worth trying that if you haven't already.
We have logged a support issue for this under reference SP-6255 / comments
I have tested this on today's SSMS 17 and can confirm that the SQL Prompt installer does not pick up the additional SSMS version if you install the same version again.
However uninstalling and rein...
Hi Curtis,
Sorry to hear that SQL Prompt isn't working for you in SSMS 2017 RC3, and that repairing it didn't work.
I tried to reproduce your problem but SQL Prompt installs successfully on a clean Windows Server 2012r2 SSMS 2017 RC3 virtual machine.
What happened when you uninstalled the first time? Or are you saying that we should be able to install into SSMS 17.0 RC3 without uninstalling?
Best wishes,
Michael Clark
Technical Lead, SQL Prompt / comments
Hi Curtis,
Sorry to hear that SQL Prompt isn't working for you in SSMS 2017 RC3, and that repairing it didn't work.
I tried to reproduce your problem but SQL Prompt installs successfully on a clean...