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

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.
Thuộc tính

ID Bài viết: 3103998 - Xem lại Lần cuối: 22-12-2015 - Bản sửa đổi: 1

Phản hồi