Activity overview
Latest activity by cfpat
Robert,
I sent you an email with scripts and screen shots.
My observations are that the SQL DOC UI will identify and show the intra db dependencies properly, but will NOT show the inter database dependencies.
However, without any other input but clicking on "Generate documentation...", the resulting documentation WILL show both inter and intra db dependencies. / comments
Robert,
I sent you an email with scripts and screen shots.
My observations are that the SQL DOC UI will identify and show the intra db dependencies properly, but will NOT show the inter database de...
Robert,
Thank you for your answer. Rather than giving you scripts of current production objects, this gave me an troubleshooting idea.
I will create a couple of test databases and cross db references with simple objects. If SQL Doc fails to identify dependencies, I will then be able to give you something fairly clean and straight forward.
Thanks for the suggestion, I should have thought of doing that myself first and we can take it from there. I hope this fails, BTW [image] the alternative would be unpalatable. / comments
Robert,
Thank you for your answer. Rather than giving you scripts of current production objects, this gave me an troubleshooting idea.
I will create a couple of test databases and cross db referen...
Robert,
Thank you for your answer. I have tried using SQL Doc from the Win Start menu, with the same results.
What is troublesome is that I have generated documentation during the selection process that identified the inter database dependencies properly. I have persisted that documentation and can definitely see that it was accurate. It fails to replicate that proper behavior now, no matter how I access the SQL Doc app.
I'm using 3.0.3.9, the latest version, and the inability to retrieve inter database dependencies manifests against SQL 2008 R2 and SQL 2014 servers alike. / comments
Robert,
Thank you for your answer. I have tried using SQL Doc from the Win Start menu, with the same results.
What is troublesome is that I have generated documentation during the selection proces...
SQL Doc fails to identify inter database dependencies
SQL Doc identifies intra database dependencies, but fails to identify the cross database dependencies. Tables used in views, tables used in SPs, etc... nothing comes through.
I am using 3.0.3.9.
...