FIX: A severe error when you use the sys.dm_db_uncontained_entities DMV in SQL Server 2014 or 2016

Symptoms

When you run a query that uses data from Dynamic Management Views (DMV) sys.dm_db_uncontained_entities, you receive error messages that resemble the following:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.

Resolution

Service pack information

The issue was first fixed in the following Service Pack for SQL Server.

Service Pack 2 for SQL Server 2014

SQL Server 2016 Service Pack 1

About Service packs for SQL Server

Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. Our recommendation is to apply the latest service pack and the latest cumulative update for that service pack. You don't have to install a previous service pack before you install the latest service pack. Use Table 1 in the following article for finding more information about the latest service pack and latest cumulative update.

How to determine the version, edition and update level of SQL Server and its components?

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

Article ID: 3172998 - Last Review: 11/16/2016 09:32:00 - Revision: 2.0

Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core, Microsoft SQL Server 2016 Standard

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB3172998
Feedback