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.
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.
