Post reply

Store Proc and View

  • May 11, 2008 at 6:54 pm

    #187458

    Hi,

    can anyone help me....

    I want to script all my additional store procs and views and run it on the other DB.

    I know how to script 1 store proc or view but I want o script all in once?

    any idea....?

    thanks,

    Susan

  • May 11, 2008 at 10:34 pm

    #813601

    Hi,

    You could use the Script Wizard available with SQL Server. Just right-click on the database in Object Explorer, go to Tasks -> Generate Scripts... Follow the wizard and select the SPs and Views you need to script.

    Regards

  • May 11, 2008 at 10:37 pm

    #813602

    Thanks.... I will try it...

    so after that I can just run it in one hit on to different DB, right

  • May 11, 2008 at 10:39 pm

    #813604

    Yes, you could...

  • May 12, 2008 at 6:23 am

    #813727

    The wizard should work. You can also select all your procedures in the Object Explorer Detail window by first clicking on the Procedures folder in the Object Explorer window. In the Object Explorer Detail window, select the procedures you want then right click and select "Script Stored Procedure as" then "CREATE To" and then you can export to a file, a new query editor window or the clipboard.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 12, 2008 at 6:14 pm

    #814171

    Thanks everyone.

    I can do it now.

Viewing 6 posts - 1 through 5 (of 5 total)

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