type of object used is not listed in xml output

Visualizes SQL Server object dependencies.

type of object used is not listed in xml output

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

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

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

Postby Brian Donahue » Fri May 23, 2008 11:55 am

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>
- <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
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests