Dependency Resolution for XML subqueries

Visualizes SQL Server object dependencies.

Dependency Resolution for XML subqueries

Postby heli2reg » Thu Sep 19, 2013 7:12 pm

I'm getting the following error :!:

Category
Parsed Dependency Resolution

Received
18.09.2013 23:21:41

Unable to resolve object '[T2].[N].[value]' in unknown database '[(local)].[T2]' referenced by stored procedure '[(local)].[MYTESTDB].[dbo].[usp_TestingSpDependenciesWithXml]'. Ensure the database exists and that you have included it in your SQL Dependency Viewer project.


Code fragment: assume #MyTempTable1 and #MyTempTable2 were created before and SP just executing fine:

Code: Select all
SELECT
   T2.N.value('local-name(.)', 'nvarchar(128)') as [FieldName],
   T2.N.value('.', 'nvarchar(max)') as FieldValue
INTO #MyTempTable2
FROM (SELECT * FROM #MyTempTable1 FOR XML PATH(''), TYPE)
AS T1(X)
CROSS APPLY T1.X.nodes('/*') as T2(N)


Is there any way to modify the code for DT being able to properly resolve :?:
heli2reg
 
Posts: 1
Joined: Thu Sep 19, 2013 7:01 pm
Location: San Luis Obispo, CA

Postby Brian Donahue » Mon Sep 23, 2013 2:50 pm

SQL Dependency Tracker does not recognize XML queries in this version and believes the top-level object is the second database of a distributed query. The bug reference for this is DT-578.
Brian Donahue
 
Posts: 6590
Joined: Mon Aug 23, 2004 10:48 am

Re: Dependency Resolution for XML subqueries

Postby ideal » Thu Feb 12, 2015 10:56 am

Why does SDT (SQL Dependency Tracker) always return focus to the first node in the tree after you’ve selected and object under one of the trees nodes? For example after I have the DB Schema loaded and I expand the node within the tree that lists all the Stored Procedures, after :oops: I scroll down towards the end of the list of Stored Procedures and click on one the focus jumps back to the first stored procedure and so I have to scroll back down to where UI was at if I need to select another object. If there is a way to multi-select and avoid this please share that otherwise can this be added to the list of fixes...............
adil
ideal
 
Posts: 1
Joined: Thu Feb 12, 2015 10:53 am


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron