Red Gate forums :: View topic - Non dependent objects
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

Non dependent objects

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



Joined: 17 Jun 2011
Posts: 3

PostPosted: Fri Jun 17, 2011 9:22 pm    Post subject: Non dependent objects Reply with quote

Hi,

I am new to SQL dependency tracker. The tool shows dependencies between the objects.
Is there any way we can find the objects which are not dependent to any other object and vice versa, so we can delete them?

Thanks,
Anjali
Back to top
View user's profile Send private message
Sian.Williams



Joined: 26 Aug 2010
Posts: 32

PostPosted: Mon Jun 20, 2011 1:51 pm    Post subject: Non dependent objects Reply with quote

Thanks for your questions.

This document has some tips that could help you Smile

http://www.red-gate.com/supportcenter/Content?c=SQL_Dependency_Tracker%5chelp%5c2.5%5cSDT_Tips.htm&p=SQL%20Dependency%20Tracker
_________________
--------------------------------------
Siān Williams
Red Gate Software
Tel: 0800 169 7433
sian.williams@red-gate.com
--------------------------------------
Back to top
View user's profile Send private message Send e-mail
anjaliv



Joined: 17 Jun 2011
Posts: 3

PostPosted: Mon Jun 20, 2011 2:55 pm    Post subject: Reply with quote

Thank you for the reply. It is very helpful Smile
Back to top
View user's profile Send private message
anjaliv



Joined: 17 Jun 2011
Posts: 3

PostPosted: Mon Jun 20, 2011 4:39 pm    Post subject: Reply with quote

I have another question.
(I) When I try to find dependency for the whole database, It shows me the tables which does not have any dependency when exported to pdf.
(II) But when I followed the procedure in the above link on the whole database, it only gives me schema and users which are independent. It does nto include any tables or stored procedures in it.
(III) But when I induvidually select tables and stored procedures, it gives me the correct result as mentioned in (I)
How can i export all the non dependent objects to pdf?

Thank you in advance.

Anjali
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Tue Jun 28, 2011 2:07 pm    Post subject: Reply with quote

I think the problem here is that when you add all database objects, then tables and stored procedures will never be independent as they will always have at least an associated schema.

You should get the results you're looking for if you only add tables and stored procedures to the diagram.

I hope this helps.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
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