Skip to content

The Dummy Programmer

Stories of daily programming

  • Home
  • The Dummy Programmer Robot
    • Overview
    • Version history & downloads
    • Tutorials
      • TDP Robot – The basics
      • A simple SQL Server backup solution
      • A simple SQL Server backup solution – A next step
  • My other dummy projects
  • Games
    • Space Y: An Asteroids clone
  • Services
    • What’s my user agent
    • What’s my IP address
  • About
  • Toggle search form

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

Posted on July 20, 2022July 21, 2022 By

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.

Sql Server, Sql Server 2019

Post navigation

Previous Post: TDP Robot version 1.0.0.0
Next Post: WebResource.axd (404) not found

Related Posts

SQL Server and SARGables predicates Sql Server
Sql Server error: Cannot construct data type date, some of the arguments have values which are not valid. Sql Server
Sql Server: apply an aggregate function to fields values in a row Sql Server
How to know who is blocking a query in Sql Server Sql Server
Get all referencing tables of a table in Sql Server Sql Server
Improving SQL Server cursor performance Sql Server

Search

Related posts

  • Remote desktop computer: an authentication error has…
  • Error message: User account restriction error
  • Sql Server error using a database with a CLR assembly
  • Sql Server error: Cannot construct data type date, some of…

Categories

  • .NET 6 (1)
  • AJAX (1)
  • Android (2)
  • Apache (4)
  • ASP.NET (9)
  • ASP.NET MVC (3)
  • Avalonia UI (1)
  • BCP (1)
  • Bitlocker (2)
  • C# (14)
  • CentOS (4)
  • ClosedXML (1)
  • CLR (1)
  • DNS (1)
  • Encryption (3)
  • Excel (2)
  • FuelPHP (3)
  • Games (2)
  • Google Chrome (1)
  • GSuite (1)
  • HTML (1)
  • Imagick (2)
  • Javascript (1)
  • Kindle (1)
  • LAMP (3)
  • Linux (6)
  • MariaDB (2)
  • Mathematics (2)
  • MySql (4)
  • NPOI (1)
  • Office 365 (1)
  • Perl (1)
  • PHP (6)
  • Programming (1)
  • Remote desktop (1)
  • SFTP (2)
  • Sockets (3)
  • Sql Server (18)
  • Sql Server 2016 (14)
  • Sql Server 2019 (1)
  • SSL (2)
  • Task scheduler (1)
  • Telerik ASP.NET AJAX (2)
  • The Dummy Programmer Chat (2)
  • The Dummy Programmer Robot (6)
  • Threading (5)
  • Tools (1)
  • TPL (3)
  • TypeScript (3)
  • Ubuntu (4)
  • Virtualization software (3)
  • Visual Studio (1)
  • Visual Studio Code (2)
  • Web fonts (1)
  • Web programming (6)
  • Windows (12)
  • Windows 10 (15)
  • Windows Forms (1)
  • Windows Server (6)

Copyright © 2023 The Dummy Programmer | Privacy Policy | Terms of use |

Powered by PressBook Masonry Dark