You may receive the following error while installing SQL Server 2017 or upgrading your SQL server from the previous version: Microsoft SQL Server 2017 Setup The following error has occurred: VS Shell installation has failed with exit code 1638. For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=0x5B39C8B9%25401434%25403 Solution This issue is caused by Microsoft Visual C++ 2017 Redistributable...
Category: SQL Server
Microsoft SQL server internal database version
Microsoft SQL server internal database version While perform some task on Microsoft SQL server, you may see the different version number in the error message as follow: The database ‘WHDdb’ cannot be opened because it is version 852. This server supports version 782 and earlier. A downgrade path is not supported. In this article...
How to open SQL Server Activity Monitor for SQL 2008 server
You can open SQL server activity monitor for your SQL 2008 server in the following two ways: You can open it from standard tool bar. From Standard Toolbar (Standard Toolbar can be made visible from here : Menu >> View >> Toolbar >> Standard) Another way, right...
Could not load file or assembly ‘Microsoft.SqlServer.Diagnostics.STrace’
You may receive the following error while starting SQL server 2008 Management Studio: The type initializer for 'Microsoft.SqlServer.Management.Dmf.PolicyStore' threw an exception. (Microsoft.SqlServer.Dmf) Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. In most cases, uninstalling Visual studio and .Net 4 and...