Comments
Sort by recent activity
Hi,
I've been using SQL Doc since version 1 and its a great product but it was missing a few things for me... so I created a "SQL Doc Cleaner" app that you can run right after creating the docs and it will do the following (taken from the about dialog): This utility allows the documentation, created by Red-Gate's SQL Doc application, to be distributed to personnel who should not have access to the SQL script.
The original HTML files are converted to remove script bodies, yet leave the header details, including comments and CREATE statement fragments, intact. Also, any tabs found in the header comments are properly formatted for display. Spaces in both the header and extended properties are correctly converted. A database version number may be specified for inclusion in the main page along with the renaming of the "Extended Properties" title. Finally, any selected supporting documentation, in Excel, PDF or Word format, is automatically hyperlinked in the main page.
I built the app to my own requirements, of course, but it works very well for me. On the specifc topic that you requested, it leaves the comments, properly formatted (so tabs align etc.), along with the CREATE statement header (including the parameters) so that application developers can see the interface. However, all the following code is replaced with a single *** Hidden Script Fragment *** text line. This occurs for all scripted objects such as procs, triggers and views.
If you think this is of use to you, let me know and I'll give you a copy.
Regards,
Gary / comments
Hi,
I've been using SQL Doc since version 1 and its a great product but it was missing a few things for me... so I created a "SQL Doc Cleaner" app that you can run right after creating the docs and...