Dependency Resolution for XML subqueries

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

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: 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