Dependency Resolution
mark_anderson_us
Posts: 37
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
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
Comments
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?