"Avoid framing block comments. It looks attractive initially but is difficult to maintain..."

Not nearly as difficult as trying to maintain code without revision notes of who did what so you can go to them for more info about "why" they changed the code and why "like that".

I have our citation as part of one of the templates we use for stored procs and scripts, so you ctrl+shift+m to populate the info and your form structure is set for you:

IF EXISTS (SELECT name

FROM sysobjects

WHERE name = N''

AND type = 'P')

DROP PROCEDURE

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS OFF

GO

CREATE PROCEDURE

= ,

=

AS

--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

--STP: procedure_name

--Author:

--Notes:

--Date:current_date

--Rev's

--

--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

SELECT @p1, @p2

GO

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

grant execute on TO PUBLIC

GO