GEOMETRY::STMPolyFromText makes SSMS crash in clr.dll

Martin Nielsen 0 Reputation points
2023-11-24T06:51:44.3233333+00:00

I have a piece of SQL code where i create a geometry using GEOMETRY::STMPolyFromText

but when I select or click in the text GEOMETRY::STMPolyFromText SSMS crashes and generates the following error in the windows log:

Faulting application name Ssms.exe, version: 2023.190.2.56, time stamp: 0x654cf880

Faulting module name clr.dll, version: 4.8.9195.0, time stamp: 0x64e9259c

Exception code 0xc00000fd

Fault offset 0x000241ac

Faulting process id 0x35e8

Faulting application start time 0x01da1e9eac27e51d

Faulting application start time as time 2023-11-24 07:23:00

Faulting application path C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Ssms.exe

Faulting module path C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll

Report Id efa3832b-3814-4d98-a402-30e38521ef72

Faulting package full name NULL

SSMS is also periodically crashing (in clr.dll) when I'm not using the above code, but that is more random in nature, in fact I once came back to my pc, looked at the screen for a few seconds and then SSMS crashed (in clr.dll) without me ever touching the keyboard or mouse.

it seems the clr.dll module needs a serious overhaul

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,339 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,600 questions
{count} votes