Red Gate forums :: View topic - type of object used is not listed in xml output
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

type of object used is not listed in xml output

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



Joined: 05 May 2008
Posts: 59

PostPosted: Mon May 05, 2008 3:12 pm    Post subject: type of object used is not listed in xml output Reply with quote

the object type is listed, but the object being used by this is not

why not?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6587

PostPosted: Fri May 23, 2008 12:55 pm    Post subject: Reply with quote

Hi Nik,

The schema of the XML export does not define the object type of dependent objects in order to reduce the size of the XML by not repeating information that is available elsewhere. For example, the XML output could show the following:
Code:

- <Object>
  <Name>[(local)].[F0012191].[dbo].[fn_MyExample]</Name>
  <Type>Function</Type>
- <Uses>
  <Object>[(local)].[F0012191].[dbo].[a]</Object>
  <Object>[(local)].[F0012191].[dbo].[b]</Object>
  <Object>[(local)].[F0012191].[dbo].[c]</Object>
  <Object>[(local)].[F0012191].[dbo].[d]</Object>
  </Uses>

In this case, the list of objects that fn_MyExample uses does not include the full information about these objects because it is expressed elsewhere.

If you had to parse this XML in order to transform it to HTML or something like that, you can use an XPATH query to select the dependent object by name and get the object type from the object definition. For instance, you could work out the type of object a with this query:
Code:
Object[@name='[(local)].[F0012191].[dbo].[a]']/Type
Back to top
View user's profile Send private message
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