Comments at start of procedure ignored

davegr

Hi,

If I create a SP as follows and then do an ALTER PROCEDURE {tab} SQL Prompt fills in the procedure code but leaves out the first comment. If the comments are moved after the CREATE PROCEDURE line then they are included.

/* comments here are ignored by Inserted Code for ALTER statements */
CREATE PROCEDURE test
/* comments here work fine */
AS
SELECT 'test' AS Col1
GO

The comments are in the procedure as they do show correctly if I use the SSMS script generation context menu options.

Can this be changed so comments at the start of a procedure are included?

Thanks

Dave

Sian.Williams

Thanks for contacting Red Gate.

I have logged a feature request for this, the ID is SP-3922. You can use that ID if you would like to chase it up in the future.