Dependency Resolution

Visualizes SQL Server object dependencies.

Dependency Resolution

Postby mark_anderson_us » Thu Aug 22, 2013 5:28 pm

Anyone goy any ideas why I'm getting this:

Parsed Dependency Resolution

8/22/2013 12:04:33 PM

Unable to resolve object '[Live_Customers].[dbo].[Company]' in unknown database '[SERVER].[Live_Customers]' referenced by stored procedure '[SERVER].[Live_Costing].[dbo].[WIPLabour]'. Ensure the database exists and that you have included it in your SQL Dependency Viewer project.

Everything looks correct and the SP iworks
Posts: 23
Joined: Sat Apr 28, 2012 7:27 pm

Postby Brian Donahue » Tue Aug 27, 2013 10:51 am

Hi Mark,

I'd probably need to see both the database schemas, assuming you have two copies of a database called Live_Customers on two different servers, which is what I *guess* you've got.

Is Company a stored procedure? How is it connected to the other database? Linked server or three-part identifier? Does it help to follow the suggestion to add the other database into the project manually?
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Re: Dependency Resolution

Postby sashasuman » Tue Dec 16, 2014 11:30 am

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.
Our Actual Exams and 300-206 brain dumps gre exam provide you 100% pass guarantee. You can get access to - 642-996 brain dumps and Principia College exams. Our Pittsburg State University is also very useful tool.
Posts: 1
Joined: Tue Dec 16, 2014 11:16 am

Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 1 guest