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


Author
Message
Charles Thomas Blankenship...
Charles Thomas Blankenship
StrataFrame User (448 reputation)StrataFrame User (448 reputation)StrataFrame User (448 reputation)StrataFrame User (448 reputation)StrataFrame User (448 reputation)StrataFrame User (448 reputation)StrataFrame User (448 reputation)StrataFrame User (448 reputation)StrataFrame User (448 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
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