SP Installation Scripts

  • Is there a way to create a script that will install all the stored procedures in the database?

    Like one click/run, it will then install the list of Stored Procedures that we created to the target database.

    Thanks,

    James

  • Script all the sps (Obj exploere->right click on db -> tasks -> generate script) from a database, store it in one single sql file, open it in the new db context, execute it!

    ---------------------------------------------------------------------------------

  • Nabha (1/21/2010)


    Script all the sps (Obj exploere->right click on db -> tasks -> generate script) from a database, store it in one single sql file, open it in the new db context, execute it!

    woah, thanks Nabha!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply