Visualizes SQL Server object dependencies.
Moderators: David Atkinson, Anu Deshpande
The Message report can have hundreds (I have 583 in one project) messages and some of them are useful but very hard to find because they are hidden among "normal" ones.
Unable to resolve object '[INFORMATION_SCHEMA].[KEY_COLUMN_USAGE]' in database '[MyServer].[MyDb]' referenced by function [snip] Ensure the SQL defining this object is correct.
Not resolving references to system objects is not a problem. Same thing with lots of unresolved references to temporary objects (mostly temporary tables).
It would be useful to be able to see meaningful messages only. Maybe 3 tabs (user objects, temp objects, system objects) or have a preference not to display some unresolved types.
ps (other topic): it is not always obvious to identify the dependency itself. For example, we have tables with both PK and UK and a foreign key sometimes is through a unique key, not the primary key.
- Posts: 24
- Joined: Wed May 24, 2006 4:16 pm
Thanks for the feedback. We will look at these for future versions of Dependency Tracker.
- Posts: 29
- Joined: Tue Dec 06, 2005 4:42 pm
- Location: Red Gate
Return to SQL Dependency Tracker 2
Who is online
Users browsing this forum: No registered users and 0 guests