FIX: Access violation when you run an INSERT, UPDATE or MERGE statement on a view that uses WITH CHECK OPTION in SQL Server 2014
<timestamp> spid<#> SqlDumpExceptionHandler: Process <#> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process
Cumulative Update informationThe issue was first fixed in the following cumulative update of SQL Server.
Recommendation: Install the latest cumulative update for SQL Server
UPDATE "<ViewName>" SET"<ColumnA>" = <NewValue> WHERE ("<ColumnB>" = <ColumnBValue>)
- 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.
Article ID: 3103998 - Last Review: 12/22/2015 03:32:00 - Revision: 1.0
- kbqfe kbfix kbexpertiseadvanced kbsurveynew KB3103998