Feature Request for SQL Doc - Stored Procedures

Documents SQL Server 2000, 2005 and 2008 databases.


Moderators: David Atkinson, david connell, Charles Brown

Feature Request for SQL Doc - Stored Procedures

Postby MarkThornton » Wed Apr 16, 2008 4:00 pm

I want to provide summaries of several Stored Procedures to a Web Developer, who will be calling them from a website that he is building. I could do this task better if SQL Doc had the following extra features:

a) For each parameter, record if it has a default. (SQL Server Management Studio gives this information.)

b) Allow me to suppress the SQL Script. It is of no interest to my audience.

Are either of these features planned for implementation? If so, please could you give me an approximate implementation date?

Thanks in advance.

Mark Thornton
MarkThornton
 
Posts: 10
Joined: Thu Feb 14, 2008 3:51 pm
Location: School of Clinical Medicine, University of Cambridge

Postby Brian Donahue » Thu May 08, 2008 2:41 pm

Hi Mark,

It is possible to omit the SQL script from the documentation by modifying the SQL Doc stylesheet. First, open %programfiles%\\red gate\\sql doc 1\\style1\\style\\master.css with Notepad. Locate the list starting with .sqlscript and add the following: visibility: hidden;. For instance:
Code: Select all
/* SQL Script */
.sqlScript #sqlScript
{
   
   padding: 5px;
   background-color: #CCCCCC;
   border: 1px solid #888888;
   font-family:Courier New ;
   font-size:90%;
   visibility: hidden;
}
Please note that the script can still be seen if your user accesses the source of an HTML documentation file, but the script will be invisible on the web page.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby MarkThornton » Thu May 15, 2008 9:01 am

Brian,

Thanks for this advice, it is helpful.

I hope you enjoyed your recent shopping trip! :D

Best wishes,

Mark
MarkThornton
 
Posts: 10
Joined: Thu Feb 14, 2008 3:51 pm
Location: School of Clinical Medicine, University of Cambridge

Postby Brian Donahue » Thu May 15, 2008 10:10 am

Hi Mark,

It was very good, thanks! I still don't know what to do with the leftover £22...
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Doc 1

Who is online

Users browsing this forum: No registered users and 0 guests