It has always struck me that SQL server doesnt have a way in which I can run automated tests or checks on the database to weed out objects that no longer work/compile/execute. As we all know, sometimes database schema changes frequently i.e a column rename
is a classical example and some stored procedures/functions which may be legacy then no longer works, in my situation a legacy application was re-written, but it was difficult picking up the objects specific to that application, so as the schema has changed,
some procs and functions no longer work, but such objects are no longer required to be on the DB, but we want to pick out the ones that no longer compiles and remove appopriately.
Any ideas ?
View Complete Post