Post reply

Push a SP out to multilple machines at once

  • October 8, 2013 at 2:40 pm

    #283664

    I have an interesting task that I need help with.

    I have over 100 machines that are running SQL Express and I need to update a SP on them. Does anyone know of a way to script this out to where I don't have to touch each machine?

    Thanks in advance for your help. :ermm:

  • October 8, 2013 at 5:20 pm

    #1656960

    You might want to look into sql-multi-script (www.red-gate.com/products/dba/sql-multi-script), a tool by RedGate.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • October 9, 2013 at 2:01 am

    #1657022

    You can also use Registered Servers in SSMS.

    http://technet.microsoft.com/en-us/library/ms173574(v=sql.105).aspx

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

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

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