Link to home
Start Free TrialLog in
Avatar of wilfordrocks
wilfordrocks

asked on

how to deploy stored procedures

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.
thanks
SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks!

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!!