And thanks from me to you for this post.

Got the details of a stored procedure with wrong block quotes that was hindering the MODIFY command with the same error message.

Here is what I found. Find the error:

/*

' --------------------------------------------------------------------- '

' Product: Product Name '

' System: System Namae '

' Subsystem: Selector '

' Function: Yyy3000ReportData_Prepare_ProjectResultFx30 '

' Owner: schema owner '

' --------------------------------------------------------------------- '

' Function: Sets the estimated time that is necessary for '

' the data preparation. Prepares the report data. '

' Updates the state in the SystemQueue. '

' --------------------------------------------------------------------- '

' Parameter: See below. '

' --------------------------------------------------------------------- '

' Sample: DECLARE @QueueId uniqueidentifier '

' SET @QueueId = NEWID() '

' EXEC <schema name>. '

' Yyy3000ReportData_Prepare_ProjectResultFx30 '

' 103 /*v16, v17: 113*/

' ,@QueueId '

' ,1 '

' ,2 '

' ,'W12489' '

' ,'001' '

' ,'0000375412' '

' ,1 '

' ,'D' '

<snipped for brevity purposes>

Alas the code is highlighted correctly in the above section, so you can see the error or what was left of the syntax issues. The comments where located before the definition of the actual sproc, which seems to be bad practice.

Funny enough the sproc was still working.

The fix was to drop the procedure and then insert back in the corrected code.

Thanks

hot2use