Red Gate forums :: View topic - Objects by owner
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Objects by owner

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SapperCS



Joined: 19 Jun 2007
Posts: 2
Location: Colorado Springs, CO

PostPosted: Tue Jun 19, 2007 4:02 pm    Post subject: Objects by owner Reply with quote

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].[owner].[table]. 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.
_________________
Daniel L Johnston Jr.
Database Developer/Administrator
Kincaid Technologies
Back to top
View user's profile Send private message AIM Address MSN Messenger
SapperCS



Joined: 19 Jun 2007
Posts: 2
Location: Colorado Springs, CO

PostPosted: Wed Jun 20, 2007 4:30 pm    Post subject: From complaint to enhancment request. Reply with quote

Ok, I have been working to get a better layout of the schema I was complaining about yesterday and have found that it does layout the map properly. All calls are going through the partitioned view and then on to the various tables.

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.
_________________
Daniel L Johnston Jr.
Database Developer/Administrator
Kincaid Technologies
Back to top
View user's profile Send private message AIM Address MSN Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group