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

Parsed Dependency Resolution

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
   T2.N.value('local-name(.)', 'nvarchar(128)') as [FieldName],
   T2.N.value('.', 'nvarchar(max)') as FieldValue
INTO #MyTempTable2
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 :?:
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