Unhelpful messages

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Unhelpful messages

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

Hi,

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.

Ex:
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.

thanks

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.

Eric
Eric
 
Posts: 24
Joined: Wed May 24, 2006 4:16 pm

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

Hi Eric,

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

Thanks
Alan.
wallacea
 
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