Feature Request for SQL Doc - Stored Procedures

MarkThornton

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

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.

MarkThornton

Brian,

Thanks for this advice, it is helpful.

I hope you enjoyed your recent shopping trip!

Best wishes,

Mark

Brian Donahue

Hi Mark,

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