type of object used is not listed in xml output

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

type of object used is not listed in xml output

Postby austrianfoodispuke » Mon May 05, 2008 3:12 pm

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

why not?
austrianfoodispuke
 
Posts: 59
Joined: Mon May 05, 2008 1:44 pm

Postby Brian Donahue » Fri May 23, 2008 12:55 pm

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: Select all
- <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: Select all
Object[@name='[(local)].[F0012191].[dbo].[a]']/Type
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests