Non dependent objects

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Non dependent objects

Postby anjaliv » Fri Jun 17, 2011 9:22 pm

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
anjaliv
 
Posts: 3
Joined: Fri Jun 17, 2011 8:46 pm

Non dependent objects

Postby Sian.Williams » Mon Jun 20, 2011 1:51 pm

Thanks for your questions.

This document has some tips that could help you :)

http://www.red-gate.com/supportcenter/C ... %20Tracker
--------------------------------------
Siân Williams
Red Gate Software
Tel: 0800 169 7433
sian.williams@red-gate.com
--------------------------------------
Sian.Williams
 
Posts: 32
Joined: Thu Aug 26, 2010 8:59 pm

Postby anjaliv » Mon Jun 20, 2011 2:55 pm

Thank you for the reply. It is very helpful :)
anjaliv
 
Posts: 3
Joined: Fri Jun 17, 2011 8:46 pm

Postby anjaliv » Mon Jun 20, 2011 4:39 pm

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
anjaliv
 
Posts: 3
Joined: Fri Jun 17, 2011 8:46 pm

Postby Chris Auckland » Tue Jun 28, 2011 2:07 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests