Stored Procedure Reporting?

I need to do some stored procedure documentation.  I am using Visio for Enterprise Architects but I can't for the life of me find a way to get Visio to report on the code reverse engineered from one of my databases!

I create a new Database Diagram, reverse-engineer my database and try to run an "Object Type" report.  That reports gives me everything EXCEPT for the stored procedures that were reverse engineered.  Visio properly imports all of my code from the database, I just can't figure out how to include it in a report!

Am I just missing something   It can't be that difficult.



Answer this question

Stored Procedure Reporting?

  • Zhang Michael

    That's a 7 year old article comparing visio 2002 to the 2002 Enterprise Architect edition of Visual Studio. It states:

    MicrosoftR Visual StudioR .NET Enterprise Architect includes advanced Visio-based modeling solutions for developers. Based on tools previously found in Microsoft Visio 2000 Enterprise Edition, Visio for Enterprise Architects includes all of the solutions in Visio Professional 2002 plus full-featured database and software modeling solutions.

    They are comparing the regular Visio 2002, to Visio for Enterprise Architects from 2002. Shawn is already using Visio for Enterprise Architects.


  • XPolter

    Here is an interesting link which suggests that what you need is available in MS Visual Studio Enterprise Architect but not visio:

    http://www.microsoft.com/technet/prodtechnol/Visio/visio2002/plan/visdbmdl.mspx

    If you find a solution for this problem in Visio please tell me.



  • Stored Procedure Reporting?