Dependency Resolution for XML subqueries

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:

SELECT 
	T2.N.value&#40;'local-name&#40;.&#41;', 'nvarchar&#40;128&#41;'&#41; as &#91;FieldName&#93;,
	T2.N.value&#40;'.', 'nvarchar&#40;max&#41;'&#41; as FieldValue
INTO #MyTempTable2
FROM &#40;SELECT * FROM #MyTempTable1 FOR XML PATH&#40;''&#41;, TYPE&#41; 
AS T1&#40;X&#41;
CROSS APPLY T1.X.nodes&#40;'/*'&#41; as T2&#40;N&#41;

Is there any way to modify the code for DT being able to properly resolve :?:

heli2reg 11 years ago

Comments

2 comments

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 11 years ago

0
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...............

ideal 10 years ago

0