Microsoft.sqlserver.types in SQL Server: gone

0

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 15.0.0.0 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=15.0.0.0, 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?

sql-server
asked on Stack Overflow Sep 1, 2020 by SWP_IB

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0