How can we help you today? How can we help you today?

Dependency Resolution

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
0

Comments

2 comments

Sort by
  • Brian Donahue
    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
    0
  • sashasuman
    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.
    sashasuman
    0

Add comment

Please sign in to leave a comment.