USE AdventureWorks;
GO
CREATE PROC dbo.InvalidProc
AS
  SELECT * FROM dbo.NotExistingTable
GO
SELECT *
FROM sys.dm_sql_referenced_entities ('dbo.InvalidProc', 'OBJECT');
GO

Msg 2020, Level 16, State 1, Line 1
The dependencies reported for entity "dbo.InvalidProc" do not include references to columns. This is
either because the entity references an object that does not exist or because of an error in one or
more statements in the entity.  Before rerunning the query, ensure that there are no errors in the entity
and that all objects referenced by the entity exist.

USE AdventureWorks;
GO
BEGIN TRAN
GO
CREATE PROC dbo.InvalidProc
AS
  SELECT * FROM dbo.NotExistingTable
GO
CREATE TABLE dbo.T1(col1 int NOT NULL)
GO
CREATE VIEW dbo.V1 AS
  SELECT T.col1 FROM dbo.T1 T
GO
sp_rename 'dbo.T1.col1', 'col2', 'COLUMN';
GO

DECLARE @T TABLE(object_name sysname)
DECLARE @Foo TABLE(col1 int)

DECLARE
  @name sysname
DECLARE Cur CURSOR LOCAL STATIC FOR
SELECT SCHEMA_NAME(o.schema_id) + '.' + name FROM sys.objects o WHERE o.type IN ('P', 'V')

OPEN Cur
FETCH NEXT FROM Cur into @Name
WHILE @@FETCH_STATUS =  0  BEGIN
  BEGIN TRY
    INSERT @Foo SELECT referencing_minor_id FROM sys.dm_sql_referenced_entities (@name, 'OBJECT')
  END TRY
  BEGIN CATCH
    INSERT @T SELECT @name;
  END CATCH;
  FETCH NEXT FROM Cur into @Name  
END
CLOSE Cur
DEALLOCATE Cur

SELECT * FROM @T

IF @@ROWCOUNT >  0  ROLLBACK ELSE COMMIT
GO
SELECT * FROM T1

object_name
--------------------------------------------------------------------------------------------------------------------------------
dbo.InvalidProc
dbo.V1

(2 row(s) affected)

Msg 208, Level 16, State 1, Line 1
Invalid object name 'T1'.

USE AdventureWorks;
GO
ALTER INDEX AK_Employee_LoginID
    ON HumanResources.Employee REBUILD;
GO

Msg 3930, Level 16, State 1, Line 26
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3998, Level 16, State 1, Line 1
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.