Saving a Stored Procedure created from MSSMS Script fails

You could think of SSIS package to create a database copy from existing one. You could make use of Transfer Db objects task

http://msdn.microsoft.com/en-us/library/ms142159.aspx

---

Satheesh