Are Cross-database dependencies available?

kakins-tamus

In the "Used By" section of a SQL object in SQL doc, I can see all objects references within the scope of a single database.  However, if that object (such as a view) is used by another database, the "Used By" section does not reflect this.  Is this the intended behavior?

Eddie D

Hi kakins-tamus

Thank you for your forum post.

SQL Doc does not show cross database dependencies.  Also it does not support Linked Servers and tables from other servers.  It will only show the objects within the single database you are generating the documentation for.

I have added the details of this forum post to an existing enhancement request whose reference is SDOC-1044. I will update this post if this enhancement appears in a later version of SQL Doc.

Many Thanks
Eddie

BobHarris

This is incorrect. My SQL Doc project contains 3 databases (on the same server) and the dependencies are definitely shown. It's a great feature and works perfectly. I only wish we could add cross server dependencies.