|
|
|
|
|
|
| |
|
Review
Finding objects like stored procedures, views, and/or user-defined functions, or even columns that are not referenced (anymore) in either the database itself and/or the client code is a very tedious task, that almost no one I know likes to undertake. Even a medium-sized database can call for a lot of trouble and endless hours of work.
Well, sure, there is a build-in system table named sysdepends in SQL Server that is supposed to do exactly this job. But unfortunately, it is not very difficult to bring this table out of synch with reality. So, you cannot rely on the mechanisms SQL Server provides itself. |
|
|
|
|