Feature Request for SQL Doc - Stored Procedures

MarkThorntonMarkThornton Posts: 21
edited May 15, 2008 5:10AM in SQL Doc Previous Versions
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
Mark Thornton
Database Developer
School of Clinical Medicine
University of Cambridge

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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,

    Thanks for this advice, it is helpful.

    I hope you enjoyed your recent shopping trip! :D

    Best wishes,

    Mark
    Mark Thornton
    Database Developer
    School of Clinical Medicine
    University of Cambridge
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Mark,

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