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|
1 = If an error occurs before all columns could be processed.
0= If all columns are processed successfully without errors.