Hook into the comment automatically added to generated stored procedures ...


Author
Message
Charles Thomas Blankenship...
Charles Thomas Blankenship
StrataFrame User (350 reputation)StrataFrame User (350 reputation)StrataFrame User (350 reputation)StrataFrame User (350 reputation)StrataFrame User (350 reputation)StrataFrame User (350 reputation)StrataFrame User (350 reputation)StrataFrame User (350 reputation)StrataFrame User (350 reputation)
Group: Awaiting Activation
Posts: 172, Visits: 12K
Currently, the generated stored procedures place a generic comment at the top of the deployed stored procedure that looks like this:

/****** Object:  StoredProcedure [dbo].[Import_Delete]    Script Date: 5/2/2013 11:23:45 PM ******/

I need to replace that with one that looks like this:

/*'============================================================================================
'  Copyright, 2013 Southend Painting and Roofing Contractors, Inc. (SEPARC) All rights reserved.
'
' This software and its associated documentation contain valuable trade secrets 
' and proprietary information belonging to SEPARC, Inc.  None of the software
' or its associated documentation may be stored in a retrieval system, copied,
' transmitted, distributed, transcribed or reproduced in any other way or disclosed
' to any third parties without the express written permission of SEPARC, Inc.  
'
' UNDER NO CIRCUMSTANCES SHALL Noavant Consulting, Inc. BE LIABLE FOR INCIDENTAL, SPECIAL,
' INDIRECT, DIRECT OR CONSEQUENTIAL DAMAGES OR LOSS OF PROFITS, INTERRUPTION OF 
' BUSINESS, OR RELATED EXPENSES WHICH MAY ARISE FROM THE USE OF SOFTWARE OR DOCUMENTATION, 
' INCLUDING BUT NOT LIMITED TO THOSE RESULTING FROM DEFECTS IN SOFTWARE AND/OR DOCUMENTATION,
' OR LOSS OR INACCURACY OF DATA OF ANY KIND.
'--------------------------------------------------------------------------------------------
' ANY USE OF THIS CODE CONSTITUTES ACCEPTANCE OF THE TERMS OF THE COPYRIGHT NOTICE
'--------------------------------------------------------------------------------------------
' DO NOT REMOVE THIS DISCLAIMER
'============================================================================================ 
' Developer:  Charles T. Blankenship
' Company:    Novant Consulting, Inc.
' EMail:      ct@novantconsulting.com
' Phone:      (704) 975-7152
'============================================================================================ */



Charles T. Blankenship
Senior Consultant
Novant Consulting, Inc.
704.975.7152
http://www.novantconsulting.com
Edited 11 Years Ago by Charles Thomas Blankenship
Trent Taylor
Trent Taylor
StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
I assume you are using the DDT.  This is a great idea for the new version of the DDT, however, at the moment you would either have to place this at the top of the procedure or use a post deployment script to go and add your sproc.  I think that if you just put your comment code at the top of the sproc you would be fine as well.  So in the DDT, after the BEGIN at the top of the sproc, you could just add your comments there.

This has just officially made the list as an enhancement request.  I am surprised that this hasn't come up before.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search