/* This is my comment */

create procedure QotdFail
as

select 1

SELECT DISTINCT
 OBJECT_NAME(id) AS [Column1]
FROM sys.syscomments
WHERE text LIKE '%This is my comment%'

CREATE PROCEDURE QOTD_Test
AS
	PRINT 'This is a test'; -- this is a comment
GO

SELECT "text" FROM sys.syscomments WHERE id = OBJECT_ID('QOTD_Test');