Dependency Resolution

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Dependency Resolution

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

Anyone goy any ideas why I'm getting this:

Category
Parsed Dependency Resolution

Received
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
mark_anderson_us
 
Posts: 23
Joined: Sat Apr 28, 2012 8:27 pm

Postby Brian Donahue » Tue Aug 27, 2013 11: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: 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 1 guest