Marking all stored procedures in a database for recompilation

I've seen a few of these scripts and they are all more complicated than they need to be. Here's a basic one (SQL 2008).


DECLARE @sql NVARCHAR(MAX) SET @sql = ''
SELECT @sql = @sql + 'EXEC sp_recompile ''[' + OBJECT_SCHEMA_NAME(object_id) + '].[' + OBJECT_NAME(object_id) + ']'';' + CHAR(13) + CHAR(10)
FROM sys.procedures

PRINT @sql
EXEC(@sql)