Object dependencies are an important part of a supportable SQL Server DB. Dynamic SQL can obfuscate dependencies and require dummy references to correct.