This code executes without error...but everything grinds to a halt when you try to modify or script it. Management Studio reports a Syntax error in TextHeader.
/*Bad comment line*/2
CREATE PROCEDURE [dbo].[GetProduct]
SELECT * FROM Product
I ran into this behavior after working an hour on a fairly complex sproc. I didn't back up my work before I ran it, assuming I could always pull it out of the database to make tweaks if necessary. Needless to say I was miffed to find that I couldn't open the stored procedure and effectively lost my work.
Thankfully, it's possible to retrieve code that's lost in this manner:
ROUTINE_Name = 'GetProduct'