Jeff, 
Just tested, and stand by what I said.
-- Comments before Create\Alter statement

CREATE PROCEDURE sp_Bletch
 @BrandID varchar(6)
AS
-- Comments After Create\Alter statement
 SELECT
  [ID]
  ,[Name]
  ,[BrandID]
 FROM...

Great post. A minor point.

If you are using VCS, TFS, or some code repository this makes sense:

 -- uspLogError logs error information in the ErrorLog table about the
 -- These...