FIX: Access violation when you run an INSERT, UPDATE or MERGE statement on a view that uses WITH CHECK OPTION in SQL Server 2014

Applies to: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise

Symptoms


When you run an INSERT, UPDATE, or MERGE statement on a view that is defined by the WITH CHECK OPTION syntax, a dump file is generated, and Microsoft SQL Server logs the following error messages in the Application log:

<timestamp> Server A user request from the session with SPID <#> generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

<timestamp> spid<#> SqlDumpExceptionHandler: Process <#> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process

Resolution


Cumulative Update information

The issue was first fixed in the following cumulative update of SQL Server.

More Information


This issue occurs only when you run an INSERT, UPDATE, or MERGE statement on a view that is defined by using the WITH CHECK OPTION syntax. For example:
UPDATE "<ViewName>" SET
"<ColumnA>" = <NewValue> WHERE
("<ColumnB>" = <ColumnBValue>)

Workaround


  • Run INSERT, UPDATE, or MERGE statements against the tables that are underlying the views that are defined by using the WITH CHECK OPTION syntax.
  • Change or re-create the applicable views to make sure that the WITH CHECK OPTION syntax is not used.

Status


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