FIX: DROP_ASYMMETRIC_KEY causes an instance of SQL Server to crash if it's rolled back from a trigger

Applies to: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core More

Symptoms


Assume that you use the SQL statement CREATE TRIGGER <trigger_name> ON DATABASE FOR DROP_ASYMMETRIC_KEY AS ROLLBACK to create a database trigger to prevent the ASYMMETRIC KEY from being dropped. However, if the asymmetric key is dropped, you may receive the following error message:

Additionally, when the instance of SQL Server terminates, a dump file is generated in the SQL Server error log folder, and a message that resembles the following is logged in the SQL Server error log file:

Resolution


This fix is included in the following cumulative updates for SQL Server:

       Cumulative Update 7 for SQL Server 2017

       Cumulative Update 3 for SQL Server 2016 SP2

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the standard terminology Microsoft uses to describe software updates.