Objects by owner
SapperCS
Posts: 3
I have a database with several tables, each with a different owner. These tables are accessed using a partitioned view. Most procedure access is done through this view. All tables within the view are of course referenced by the owner IE: [database].b]owner[/b.. Each of the tables and the view (owned by dbo) are all named the same table name.
This is causing Dependency Tracker to display each procedure that depends on the view to directly report as depending on each table as opposed to depending on the view, then having the view depend on the tables. Maps for quite a messy view in DP.
Is there a tag I can add to my code, or a setting I can set in DP to display properly, or am I out of luck because of my database schema.
Thanks.
This is causing Dependency Tracker to display each procedure that depends on the view to directly report as depending on each table as opposed to depending on the view, then having the view depend on the tables. Maps for quite a messy view in DP.
Is there a tag I can add to my code, or a setting I can set in DP to display properly, or am I out of luck because of my database schema.
Thanks.
Daniel L Johnston Jr.
Database Developer/Administrator
Kincaid Technologies
Database Developer/Administrator
Kincaid Technologies
Comments
I would like to request that the object owner be displayed in the object box within the map. This would make identifying the same named objects possible on printout. The object owner does display as a tool tip when I hover my mouse, but kind of tough to do just that when I have printed out the map.
Sorry for the mis report earlier. Love your tool, keep up the good work.
Database Developer/Administrator
Kincaid Technologies