views:

30

answers:

1

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