Red Gate forums :: View topic - Dependency Resolution for XML subqueries
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Dependency Resolution for XML subqueries

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
heli2reg



Joined: 19 Sep 2013
Posts: 1
Location: San Luis Obispo, CA

PostPosted: Thu Sep 19, 2013 7:12 pm    Post subject: Dependency Resolution for XML subqueries Reply with quote

I'm getting the following error Exclamation

Quote:
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
   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 Question
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6589

PostPosted: Mon Sep 23, 2013 2:50 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group