FIX: Error when your stored procedure calls another stored procedure on a linked server in SQL Server 2014

Symptoms

Assume that you create a linked server to an instance of Microsoft SQL Server 2014 Service Pack 1 (SP1). When you run a stored procedure that calls another stored procedure on the linked server, and you pass a large object as the input parameter, the query fails. Additionally, you receive the following error message:
Error: 17065, Severity: 16, State: 1.
SQL Server Assertion: File:< tmpilb.cpp>, line = 3280 Failed Assertion = 'fFalse' Release. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

Resolution

Hotfix information

This hotfix is included in the following cumulative update of SQL Server 2014 SP1:
About cumulative updates for SQL Server
About cumulative updates for SQL Server

Hotfixes that are included in this package

Prerequisites

You must have SQL Server 2014 SP1 applied before you can install this hotfix.

Registry information

To use the hotfix in this package, you don't have to make any changes to the registry.

Restart requirement

You may have to restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix doesn't replace a previously released hotfix.

Status

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

Properties

Article ID: 3097972 - Last Review: May 6, 2016 - Revision: 1

Feedback