SSMS 18.0 tabs don't display proper contents
I'm getting this CONSTANTLY on my new install of SSMS 18.0, and it's DANGEROUS. I'll open several tabs, and when I switch from one tab to another, the contents of the window don't change... I'm still looking at the old tab's contents with the new tab selected. It doesn't ALWAYS happen, but it happens at least half the time... FREQUENTLY. Further, I can close a tab, and the contents of the closed tab will still display under the new "top most" tab. This can lead to making changes to the wrong file, or being confused, and losing code. This is a seriously terrible bug. I'm downgrading back to 17.9.1, where I never experienced this issue due to this and other breaking bugs.
Matt Cowans commented
I had this problem, I solved it by going to Tools->Options and under Visual experience on the General Page.
I had to uncheck "Use hardware graphics acceleration if available" check box.
"Automatically adjust visual experience based on client performance" checkbox has to be unchecked first
Andreas Goretzky commented
I have to say that many SSMS versions between 17.0 and 18.5 have severe bugs. 18.5 does freeze frequently and lags terribly... the server context menu entry "properties" takes about 25 seconds to open, connection to a server from a management computer takes 10-15 seconds. That is inacceptable. The 18.0 did miss some context menu options, 18.1 had a bug with database restore (I couldn't provide the path for the log file) ...
Come on! DBAs cant rely on SSMS to display the correct thing? Seriously? Not acceptable. Must do better Microsoft. The money that a SQL Enterprise license costs - I MUST be able to rely on SSMS 100%. No excuses. New versions HAVE TO be properly tested for backwards compatability BEFORE they're released. Not by the user community - by you. Bugs like this are a real pain in the a** for everyone.
Steve Wolfe commented
I am having this same exact issue, and have attached a .gif for visibility. You can see that clicking between two tabs, it preserves the values of 1 until I highlight/select it. When I do that, it'll change to what it should be showing. This needs to be fixed, ASAP!
Shon Thompson commented
I've been having this problem since 2008R2. I didn't have this problem with version 17 until I installed version 18. I can't imagine a bug more serious than not knowing what code you are executing. Fix it already.
I am experiencing this as well on 18.4. In my opinion this is a critical error that should be fixed immediately.
I had this problem and I went to Tools->Options and under Visual experience on the General Page.
I only had to clear the "use hardware graphics acceleration if available" check box.
You need to first clear "Automatically adjust visual experience based on client performance" checkbox.
I ended up with the settings pictured in attached image.
2019-12-16 Got bit by this bug randomly today... I had upgraded to 18.4 about a month ago but only now started suffering from these symptops. Ran get-hotfix and no recent updates for 10 days.
--Thanks for posting the fix.
Below link helped me..!!
Found Solution. Make sure you untick all 3 checkboxes in this post https://superuser.com/questions/1319376/sql-server-management-studio-graphical-glitches
I can't change to another SQL query because it is slow loading or not loading the interface correctly
Jeremiah Davis commented
I'm forced to use this product, and I hate every minute of it. I just lost a large needed query because of this bug.
I'm seeing this problem all the time, too. I've seen in in 18.1 and hoped that 18.2 would fix but it hasn't. Yes it is dangerous!!
I hope they make this a high priority to fix!
drove me crazy for about 20 minutes until i realized what was happening...v 18.2
Ctrl Tab from one tab with lots of text to another tab with little text and the first tab stuff displays in the bottom half of the new tab!
SQL Server Management Studio 15.0.18142.0
Microsoft Analysis Services Client Tools 15.0.1389.0
Microsoft Data Access Components (MDAC) 10.0.18362.1
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.18362.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.18362
Goodbye SSMS. Time to learn to VS2019 Data Tools.
I'm running into the same issue. Did any of you get this resolved?
Mark Burns commented
touch the scroll bars a sec and the view redraws correctly.
same on ssms 18.1
I am also experiencing this problem with the latest SSMS 18.0 - switching between tabs creates a corrupted mish-mash of contents of the two tabs, instead of cleanly switching from one to the other. I hope this can be addressed soon. I personally did not have this problem with SSMS 17.x or prior - this is a new problem to me with SSMS 18.0
Just noticed this today as well