January 21, 2010 at 12:50 am
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
January 21, 2010 at 1:23 am
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!
---------------------------------------------------------------------------------
January 28, 2010 at 8:12 pm
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