How can we help you today? How can we help you today?

Feature Request for SQL Doc - Stored Procedures

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
0

Comments

3 comments

Sort by
  • Brian Donahue
    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: 
    /* 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
    0
  • MarkThornton
    Brian,

    Thanks for this advice, it is helpful.

    I hope you enjoyed your recent shopping trip! :D

    Best wishes,

    Mark
    MarkThornton
    0
  • Brian Donahue
    Hi Mark,

    It was very good, thanks! I still don't know what to do with the leftover £22...
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.