Forum

Do you mean VS 2008 database projects? SSMS 2008 Projects? That TFS thing that I cannot seem to remember the name of?

Sounds like a bug to me. What I would suggest creating the objects like this:

Create Procedure schema.name

@param1 datatype

AS

/*

comments here

*/

Not as hard as you might think.

/*comments here*/

CREATE Procedure dbo.test

AS

BEGIN

       select 1

END

GO

 

DECLARE @Definition varchar(max)

DECLARE @comments varchar(max)

DECLARE @ProcTop varchar(max)

DECLARE @ProcBottom varchar(max)

 

DECLARE @StartComment int

DECLARE @EndComment int

DECLARE @StartProc int

SELECT @Definition=OBJECT_DEFINITION(OBJECT_ID('dbo.Test'))

 

SET @StartComment = CHARINDEX('/*',@Definition)

SET @EndComment = CHARINDEX('*/',@Definition)

SET @StartProc = CHARINDEX('BEGIN',@Definition)

SET @comments = SUBSTRING(@Definition,@StartComment,@EndComment+1)

SET @ProcTop = SUBSTRING(@Definition,@EndComment+2,@StartProc-@EndComment)

SET @ProcBottom = SUBSTRING(@Definition,@StartProc+5,LEN(@Definition))

 

PRINT @ProcTop + (CHAR(13)+CHAR(10)) + @Comments + @ProcBottom

Just loop your objects and do dynamic sql. You'll want to replace Create Procedure with Alter Procedure.

So while doing some research I came across this. Not exactly what I wanted to see….

http://social.msdn.microsoft.c…..44961aa91b