June 9, 2005 at 3:07 pm
What'S that supposed to mean Sharky??
June 23, 2005 at 11:26 am
This thread got a little off topic, but I thought I'd report back with the progress I've made so far, and get feedback on thoughts/suggestions.
The Populate tab is used to query server/database(s)/proc(s) and extract the information necessary for the end result - identifying data manipulation statements and executions of other procedures.
http://www.themintons.net/SQLProcParser/Proc_Parser_Populate_Tab.jpg
The Query tab is used to display the parsed procedures, and allows for drilling down into subsequently executed stored procedures. If a statement is clicked on, you are taken to that portion of the procedure, and the statement is highlighted in red.
Note that the master database procs in this screenshot don't expand, that's because the master database wasn't exported.
http://www.themintons.net/SQLProcParser/Proc_Parser_Query_Tab_Vertical_View.jpg
A Horizontal view is available as well.
http://www.themintons.net/SQLProcParser/Proc_Parser_Query_Tab_Horizontal_View.jpg
Note the second pane in the status bar shows the number of direct calls, as well as the total number of calls made at any level.
http://www.themintons.net/SQLProcParser/Proc_Parser_Query_Tab_Status_Bar.jpg
Exporting to HTML is available as well, and the exported copy allows you to jump to particular parts of a proc (similar to clicking on an update/insert/delete/exec[cute] statement in the application) via HTML tags.
http://www.themintons.net/SQLProcParser/Proc_Parser_Export.jpg
The actual parsing can take some time (up to a 5 minutes or so for a really large set of complex stored procedures), but after the initial parsing, the data is cached so subsequent views take less than a second to query.
June 27, 2006 at 12:57 am
BI Documenter might be what you are looking for. It does SQL Server and Analysis Services databases and supports SQL Server 2000 and 2005.
Viewing 3 posts - 46 through 47 (of 47 total)
You must be logged in to reply to this topic. Login to reply
