A Stored Procedure to Create a Set of Stored Procedures

Question

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

Answer 1

I am also doing same kind of job through the dynamic sql

---

" Education is the beginning of transformation. Dedicate yourself to daily learning via Blogs/Forums/books and coaching "
Click here to read my blog

Answer 2

If the procedures are the same for every database why not just put them in the 'model' database and the create database statement will copy them to the new database.

---

Tom G.

Answer 3

Perfect.  I was not aware of the purpose of the model database.  Thanks for the info.

---

Nick's Programming Tips