Options

type of object used is not listed in xml output

austrianfoodispukeaustrianfoodispuke Posts: 100
edited May 23, 2008 7:55AM in SQL Dependency Tracker
the object type is listed, but the object being used by this is not

why not?

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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:
    - <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:
    Object[@name='[(local)].[F0012191].[dbo].[a]']/Type
    
Sign In or Register to comment.