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

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: 
Recommendation: Install the latest cumulative update for SQL Server

Status

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

คุณสมบัติ

รหัสบทความ: 3168710 - การตรวจสอบครั้งสุดท้าย: 22 ก.ย. 2016 - ฉบับแก้ไข: 1

คำติชม