Is it possible to use a stored procedure to create a bunch of other stored procedures? When the user creates a new database, I need to create a bunch of stored procedures and I would like to just run a stored procedure on the new database that creates
all the needed stored procedures. I tried just putting the CREATE PROCEDURE syntax inside a stored procedure and got some errors. I imagine this can be done using dynamic sql and the EXECUTE function but I was hoping there was a better way.
Thanks.
Nick
Nick's Programming Tips