Written by:R Teachout
3/31/2007 9:32 PM

 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)

TrackbackPrint

Location: BlogsRamblings, Scriptlets, and more!MSSQL Scriptlets

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel