FIX: CONTEXT_INFO returns incorrect values when context_info ends with two trailing zeros in SQL Server 2014 or 2016

Applies to: SQL Server 2014 ExpressSQL Server 2014 ExpressSQL Server 2014 Standard More

Symptoms


Assume that you use the CONTEXT_INFO system function in SQL Server 2014 or 2016. When you assign a hexadecimal value that ends with trailing zeros to context_info, every combination of two trailing zeros ('00') is truncated. Therefore, when you retrieve the context_info value by using the CONTEXT_INFO function, wrong values are returned.

Resolution


The issue was fixed in the following cumulative updates of SQL Server: 

Status


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