Unhelpful messages

Visualizes SQL Server object dependencies.

Unhelpful messages

Postby Eric » Mon Jan 08, 2007 7:48 pm


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 3:16 pm

Postby wallacea » Fri Jan 12, 2007 10:37 am

Hi Eric,

Thanks for the feedback. We will look at these for future versions of Dependency Tracker.

Posts: 29
Joined: Tue Dec 06, 2005 3:42 pm
Location: Red Gate

Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests