I just published a new article about a real problem I faced in January. One junior member of the team modified the definition of a database table without checking the dependencies. All of sudden, many stored procedures started to crash!

The full article is available from http://www.emoreau.com/Entries/Articles/2010/02/Validating-database-objects.aspx.