Applies ToSQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use)

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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.