As we know, it is possible to compile and to have so stored procedures:
CREATE PROC dbo.MyProc1 AS SELECT * FROM Not_Exists_Or_Removed_Table
CREATE PROC dbo.MyProc2 AS SELECT Id ,Removed_Column FROM MyValidTable
The table Not_Exists_Or_Removed_Table is not exists or was removed (MyProc1) and column Removed_Column was removed (MyProc2).
How to detect and prevent creating so stored procedures?