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

Charles Thomas Blankenship — Fri, 03 May 2013 10:03:09 GMT

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:

/*'============================================================================================

' 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

'============================================================================================ */

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

Trent L. Taylor — Fri, 03 May 2013 10:03:09 GMT

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.

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Hook into the comment automatically added to generated stored procedures ...

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

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