SQL Server 2008 doesn't always report a compile error when a stored procedure references an object that doesn't exist. Is there a way to cause it to always report errors?
A:
This option was suggested to Microsoft in 2005:
Apparently, there is still no option yet to get an error when a stored procedure that references an undefined object is created.
Erland Sommarskog, an SQL Server MVP had proposed one solution in the following article:
Daniel Vassallo
2010-02-24 23:20:02