how to deploy stored procedures

Posted on 2011-10-20
Last Modified: 2012-05-12
Using SQL 2008 I have created four stored procedures and one view.
What is the equivalent of an install or reg-update for SQL?
I just want as simple a way as possible to make a package or something that can be moved and installed on x number of instances of this database.  Something one step above copy and paste would be good.
I have no experience in this field.  Any  suggestions?  Security is not a concern.
Question by:wilfordrocks
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3]
    what about a batch job using SQLCMD tool to run a -sql file with the CREATE (or ALTER) scripts
    LVL 68

    Accepted Solution

    In SQL 2008 SSMS, you can create a local server group with all the instances you need in it, then when you run the CREATE and other other statements, they all run against all of the instances automatically.
    LVL 68

    Expert Comment


    Sorry I didn't flesh that answer out, didn't have time then.

    I'm guessing you researched it yourself :-) .

    Just to be sure, in SQL 2008 SSMS, you create a Local Server Group(s), with any name(s) you want, under "Registered Servers" tab/task.

    Then you right-click on the Group name, and select "New Query".  You code/paste your query in there, and when you run, it will automatically run against all instances in that group.

    Pretty sweeeeet!!


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now