问题:
最近因为项目原因,本来用的是SQL server 2017,需要降级到SQL server 2014. 我的电脑是surface book2 ,由于高分辨率的原因,导致SSMS的显示存在bug,这里给出解决的办法。
这张图片是参考链接里面的,因为我已经改过来了,懒得改回去截图!
解决方案:
- 添加注册表信息
注册表编辑器——>路径[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SideBySide]——>新建一个DWORD(32位)(值),名称为:PreferExternalManifest ——>将数值数据修改为1,确定即可。
- 添加配置文件
新建文本文件,并将文件重命名为:Ssms.exe.manifest ——> 将该文件放到 ssms.exe 所在的路径之下【C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio】——>重新启动SSMS即可。
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0" xmlns:asmv3="urn:schemas-microsoft-com:asm.v3">
<dependency>
<dependentAssembly>
<assemblyIdentity type="win32" name="Microsoft.Windows.Common-Controls" version="6.0.0.0" processorArchitecture="*" publicKeyToken="6595b64144ccf1df" language="*">
</assemblyIdentity>
</dependentAssembly>
</dependency>
<dependency>
<dependentAssembly>
<assemblyIdentity type="win32" name="Microsoft.VC90.CRT" version="9.0.21022.8" processorArchitecture="amd64" publicKeyToken="1fc8b3b9a1e18e3b">
</assemblyIdentity>
</dependentAssembly>
</dependency>
<trustInfo xmlns="urn:schemas-microsoft-com:asm.v3">
<security>
<requestedPrivileges>
<requestedExecutionLevel level="asInvoker" uiAccess="false"/>
</requestedPrivileges>
</security>
</trustInfo>
<asmv3:application>
<asmv3:windowsSettings xmlns="http://schemas.microsoft.com/SMI/2005/WindowsSettings">
<ms_windowsSettings:dpiAware xmlns:ms_windowsSettings="http://schemas.microsoft.com/SMI/2005/WindowsSettings">false</ms_windowsSettings:dpiAware>
</asmv3:windowsSettings>
</asmv3:application>
</assembly>
结果:
参考链接:
链接: SSMS in High-DPI Displays: How to Stop the Madness.
链接: How to enable High-DPI in SSMS (SQL Server Management Studio) – Tips, tricks and issues.
链接: Windows scaling issues for high-DPI devices.