Mar31Written by:R Teachout
3/31/2007 9:32 PM 
This allows you to set the permissions on all of the stored procedures (except the built-in ones) on a database.. great after a SQL Recovery
DECLARE @Login varchar(50)
SET @Login = '[websiteuserhere]'
SELECT 'Grant exec on [' + [name] + '] To ' + @Login
FROM [sysobjects]
WHERE [xtype] = 'P' AND [name] LIKE '%' and [name] not like 'dt_%' and [name] not like 'xp_%'
Update: (This should work for SQL2005 also)
Tags: