FIX: Access violation occurs when you update compressed data in SQL Server 2012 or 2014

Applies to: SQL Server 2014 EnterpriseSQL Server 2014 EnterpriseSQL Server 2014 Standard

Symptoms


Assume that you update compressed data by using a parameterized query in Microsoft SQL Server 2012 or 2014. When the data type in the query doesn’t match the data type in the target table or the length of the parameter in the query doesn’t match the length of the column in the target table, an access violation may occur.

Cause


This issue occurs because SQL Server can’t allocate additional memory for the parameters.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.