ApexSQL Clean: Impact Analysis and Graphical Dependency Viewer tool
The next page allows you to fine-tune the general search settings a bit. The first and last options are self-explaining. The second option “Ignore Trigger Reference to Parent Table” needs a little bit of explanation. So, here’s an excerpt from the ApexSQL Clean Online Manual:
Ignore Trigger Reference to Parent Table: (Default = False)
Triggers are unique in that they reference the table they are created on but are not really an external reference. Dropping the table will automatically drop the triggers created on it, so this option allows the user to ignore triggers for the purpose of tracking a table’s references and eliminating trigger references as true parent references.
As you can see from the above screenshot, ApexSQL Clean is SQL Server 2005 ready. The only database objects currently not supported are Certificates, Symmetric keys and Asymmetric keys. Support is already implemented in the development release, but not yet available in the publicly downloadable version, so you can expect “official” support in an upcoming release in the near future.
This page should demonstrate that the software allows you to customize your analysis requirements to any degree of granularity you need. Simply check all the object types you wish to be analysed. And if you need to drill down deeper, check the “Use Filter” box to bring up a Regular Expression Filter that lets you specify the patterns to be matched. After checking the Pattern Filter, the filter will be executed against the database and returns all objects matching the criteria. Especially for larger databases with many objects this feature comes in handy.