Options

SQL Doc not showing dependencies

DougYDougY Posts: 4 Bronze 1
in SQL Doc
Using SQL Doc to check views and SP, and it does not show the dependencies for any object (neither Used By nor Uses).  I tried using it from SSMS, and opening SQL Doc directly.  I am pretty sure that an earlier version was showing the dependency information.

Examples: A view is being used by a few SP, but that dependency does not show.

SQL Doc version 4.0.9.1300
SQL Server 2012

What am I missing?

Thanks,



Tagged:
· Share on Twitter

Answers

  • Options
    RichardLRichardL Posts: 417 Gold 4
    Hi @DougY

    Thanks for your post. 

    Can I just check that you've ticked and have included the 'uses' and 'used by' options? Is this in the set up part or in the documentation produced? 

    A screenshot would be great if possible. 

    Regards

    Richard Lynch. 
    Customer Support
    Redgate Software
    · Share on Twitter
  • Options
    DougYDougY Posts: 4 Bronze 1
    Hi Richard,

    Both options are checked.  I recall in an earlier version seeing the dependency list populated for the same SP.

    I attached two screen shots: The SQL Doc, and SQL Search results for the same SP.  The SQL Search shows the objects that use the SP in question.

    Thanks,


    · Share on Twitter
Sign In or Register to comment.