The Reporting dependencies have never really been consistent or reliable in SQL
Server. The difficultly is that when objects are added, modified or
dropped, special actions must be taken by the database engine to ensure
that the dependency chain is correct. In 2008, new dynamic management
views generic pharmacy are included to keep track of these dependencies so that reliable
reporting can be done on these objects.