Ken@Work (8/18/2010)
I've added ddl_admin to the people that need to execute this Stored Procedure.
Just bear in mind that ddl_admin gives them the permission to create, alter and drop any table, view, procedure, function, etc in the database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability