Missing System Dependencies

nk002nk002 Posts: 2 New member
in SQL Dependency Tracker
Is there a way to get missing system dependencies to resolve? The largest one I have is msdb.dbo.sp_send_dbmail. I have msdb included in the project but it cannot resolve the stored procedure.
Tagged:
· Share on Twitter

Answers

  • Alex BAlex B Posts: 1,157 Diamond 4
    Hi @nk002,

    Are you using the option "Show filegroups and system object dependencies" as described on this page?

    If not, please try this option; if you are using this option then I'll need to get more information on how the objects are connected to see if I can reproduce the issue here.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • nk002nk002 Posts: 2 New member
    That solved part of the issue. The issue I was having was seeing all stored procedures we have using msdb.dbo.sp_send_dbmail.  Once I checked that it was able to link all of them using the same msdb call however it still shows up as an Unresolved Internal Reference (Object not found) on my Dependency Diagram. No perfect but definitely usable.
    · Share on Twitter
  • Alex BAlex B Posts: 1,157 Diamond 4
    Hi @nk002,

    Good stuff, I'm glad it's usable having enabled that option! 

    I've also found an enhancement request DT-436 that seems to be related to the Unresolved Internal Reference you mention and put a reference to this post there.  It seems that they don't drill into the system dependencies to avoid clutter, but the request was for first level reference of system objects.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.