In recent days I was working on one of my projects, in which it was necessary to install Sql Server 2019. I restored the database I was working on in this new Sql Server instance and I started using it.

Calling one of the database’s stored procedure, which worked perfectly in the previous Sql Server version, I got the following error:

Msg 596, Level 21, State 1, Line 0

Cannot continue the execution because the session is in the kill state.

Msg 0, Level 20, State 0, Line 0

A severe error occurred on the current command.  The results, if any, should be discarded.

A strange error since, as I said before, in the previous version of Sql Server I had no problems.

I noticed that my version of SQL Server was as follows:

Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)   Sep 24 2019 13:48:23   Copyright (C) 2019 Microsoft Corporation  Developer Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)

Searching on Microsoft site I saw that there are several cumulative updates for Sql Server 2019, so I downloaded and installed the most recent.

Completed the installation, my SQL Server version was the following:

Microsoft SQL Server 2019 (RTM-CU16) (KB5011644) - 15.0.4223.1 (X64)   Apr 11 2022 16:24:07   Copyright (C) 2019 Microsoft Corporation  Developer Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)

The version went from 15.0.2000.5 to 15.0.4223.1 and, of course, I tried to execute the offending stored procedure again, and…. it worked! It was therefore only a problem related to the version of SQL Server, which was solved by performing an upgrade.