Update adds a new column to DMV sys.dm_sql_referenced_entities in SQL Server 2014 and 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Details


Starting from Microsoft SQL Server 2012, errors raised by sys.dm_sql_referenced_entities (such as when an object has undergone a schema change) cannot be caught in a TRY...CATCH Transact-SQL block. While this behavior is expected in SQL Server 2012 and above, this improvement introduces a new column that's called is_incomplete to the Dynamic Management View (DMV).

Column name Data type Description
is_incomplete bit

1 = If an error occurs before all columns could be processed.

0= If all columns are processed successfully without errors.

More Information


To get more information about the DMV sys.dm_sql_referenced_entities, you can refer to the following link:

sys.dm_sql_referenced_entities (Transact-SQL)

Resolution


Service pack information for SQL Server

This update is included in the following service packs for SQL Server:

       Service Pack 2 for SQL Server 2016

       Service Pack 3 for SQL Server 2014

References


Learn about the terminology that Microsoft uses to describe software updates.