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

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.

Recommendation: Install the latest cumulative update for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates for 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.
Properties

Article ID: 3103998 - Last Review: 12/22/2015 03:32:00 - Revision: 1.0

Microsoft SQL Server 2014 Service Pack 1

  • kbqfe kbfix kbexpertiseadvanced kbsurveynew KB3103998
Feedback