I have run into a strange issue regarding assembly Microsoft.sqlserver.types. I need this assembly to run a Visual Studio made assembly in which spatial functionality is involved.
In SSMS, if I look under MyDatabase-Programmability-Assemblies I see that Microsoft.sqlserver.types is there with properties: version 18.104.22.168 and creation date 24-9-2019.
However, if I run
SELECT clr_name FROM SYS.ASSEMBLIES
I get the message
An error occurred while executing batch. Error message is: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040).
So, it's not there for some reason. Though I see it in C:\Program Files\Microsoft SQL Server\150\DTS\Extensions\Common.
What can I do to get it back?
User contributions licensed under CC BY-SA 3.0