Activity overview
Latest activity by Davidian
Ben_P said:
The issue seems to be due to SSMS 19.3 using MDS 3.1.5 whilst SQL Prompt uses 3.1.1. Whilst the team work on a solution for this, it is recommended to use an earlier version of SSMS, such as 19.2 or 18.12.1. Users have also reported that downgrading SQL Prompt to 10.4.4 has worked for them: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.4.4865.exe
Hi Ben - what's the solution for the latest issue where the column picker etc stopped working randomly and upgrading has not hellped? / comments
Ben_P said:
The issue seems to be due to SSMS 19.3 using MDS 3.1.5 whilst SQL Prompt uses 3.1.1. Whilst the team work on a solution for this, it is recommended to use an earlier version of SS...
Nikolai_Sklobovsky said:
Went several version back down to May 1st. Same stuff. Intellisense suggestions don't work... [image]
Hi, yes, Redgate had been nagging me to update for ages but i didn't want to due to the issues with intellisense not working. I hadn't upgraded SSMS or Redgatge and intellisense stopped working anyway... So I upgraded redgate, no joy, upgraded SSMS, still not working. Formatting still works but the column picker etc is where I get most of my Gains. Frustrating to be back here... again. / comments
Nikolai_Sklobovsky said:
Went several version back down to May 1st. Same stuff. Intellisense suggestions don't work...
Hi, yes, Redgate had been nagging me to update for ages but i didn't ...
@hassan_imam - I haven't tried the latest version - this post a from ben at the bottom of this thread seems to indicate there is still an issue that hasn't been resolved though: https://forum.red-gate.com/discussion/90375/anyone-else-have-suggestions-not-working-in-latest-update-of-sql-prompt I don't have the time to update and test right now, because if it doesn't work there isn't a "downgrade" option, you have to uninstall and reinstall and believe it or not, I am up against the wall at the moment. / comments
@hassan_imam - I haven't tried the latest version - this post a from ben at the bottom of this thread seems to indicate there is still an issue that hasn't been resolved though: https://forum.red-g...
Hey Ben, I think it is also the AAD (Azure active directory - Integrated) version [image] [image] / comments
Hey Ben, I think it is also the AAD (Azure active directory - Integrated) version
Ok, so, sort of - I have that one set to 180 turning it off sorts that FOR statement, but also this: [image] [image] [image] becomes: [image] So it seems like there is no way to balance having both The closest from here seems to be if I change List items from always to if longer than wrap column [image] [image] however other statements like: [image] become [image] Which is sort of the reverse of what I am going for with those ones lol. I will have to keep playing. / comments
Ok, so, sort of - I have that one set to 180turning it off sorts that FOR statement, but also this:becomes:So it seems like there is no way to balance having bothThe closest from here seems to be i...
sure.. I mean this is just an extract with some begins and the like to show you the indentation effects applied upon a CTRL+K+Y - there's obviously more to the procs we use but it happens in all circumstances and this should suffice to demonstrate the issue - screenshot attached as well. <br><div>BEGIN</div><div>BEGIN TRY</div><div>IF 1 = 1</div><div>BEGIN</div><div>SELECT [ValuationDate] = [Date],</div><div> FulcrumEntityId,</div><div> Parent_Portfolio,</div><div> Parent_PortfolioId,</div><div> [TotalFundValue] = [Total Fund Value],</div><div> [AggregatesValue] = [Aggregates],</div><div> AggregatesVsTotalFundPercent = [Aggregates] / NULLIF([Total Fund Value], 0)</div><div> INTO #tblPivot</div><div> FROM (SELECT FulcrumEntityId, Parent_Portfolio, Parent_PortfolioId, PortfolioType, [Date], Valuation FROM #tblAggregateValue) UFV</div><div> PIVOT (SUM(Valuation)</div><div>FOR PortfolioType IN ([Total Fund Value], [Aggregates])) PivotData;</div><div>END;</div><div>END TRY</div><div>BEGIN CATCH</div><div>PRINT 'Error';</div><div>END CATCH;</div><div>END;</div><div><br></div>
[image] [image]
/ comments
sure.. I mean this is just an extract with some begins and the like to show you the indentation effects applied upon a CTRL+K+Y - there's obviously more to the procs we use but it happens in all c...
Changing the default Complete Suggestion button
I understand there is a selection of the default buttons to complete suggestionbut is there a way to change this to use a modifier?Tab is the perfect button for this, but I have another plugin with...
Just to confirm - the latest 2 editions for SQL prompt do not work, the downgrade to SQL prompt 10.14.4.4865 gets things working again though. / comments
Just to confirm - the latest 2 editions for SQL prompt do not work, the downgrade to SQL prompt 10.14.4.4865 gets things working again though.
Indentation mising on Pivot Tables FOR
This indentation on the FOR command is missing for pivot tables. This isn't obvious if the pivot is your only command but even wrapping it in an BEGIN and END you can see how the rest of the comman...
Just wanted to confirm: 10.14.4.4865 works It took me refreshing a few times, both the connection and the suggestions, but they populated after that - and yes, I tried this on the other versions too but without much avail. Hopefully Redgate get this resolved in their next release. / comments
Just wanted to confirm: 10.14.4.4865 worksIt took me refreshing a few times, both the connection and the suggestions, but they populated after that - and yes, I tried this on the other versions too...