• I prefer to add my comments after the create procedure, eg

    create proc rpcNameOfProc

       @AcctMonthEndDate datetime

    as

    --Custom script created for Client

    --This script should be reinstalled and tested at time of an upgrade.

    --Name - rpcNameOfProc

    --Version - 4

    --Author - Gareth Mercer

    --Create Date - 20 October 2004

    --Description - Used for the report Report.rpt

    That way when you're at a client's and you want to know what version they have, you can do an

    sp_helptext, rather than rely on the client to have a record.