Set EXECUTE on SQL stored procedures

If you have created and restored a SQL database, the stored procedures may need to have EXECUTE privilege set on them. If there are lots of these procedures, it can be tedious to do it by hand. The query below will output the T-SQL command(s) to set EXECUTE on each procedure. You can then copy/paste the result and execute it.

USE [DbNameHere]
SELECT 'GRANT EXECUTE ON ' + name + ' TO [NT AUTHORITY\NETWORK SERVICE]'
 FROM sysobjects
 WHERE type = 'P' AND name like 'sp_%'