About
Pricing
Community
Teams
Start Free Trial
Log in
iscivanomar
asked on
7/13/2011
How to create a script that will update all stored procedures in SQL Server 2008 R2?
I need to update all the store procedures in a database.
First, delete them and then create them again.
Thank you.
Microsoft SQL Server 2008
Microsoft SQL Server 2005
7
4
Last Comment
iscivanomar
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Banthor
7/13/2011
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Banthor
7/13/2011
Batch file to execute all files in a folder
SOLUTION
jorgedeoliveiraborges
7/13/2011
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
G Trurab Khan
7/14/2011
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
iscivanomar
7/15/2011
ASKER
Ghunaima: How can I select all the storeprocedures, if I right click the mouse, only one Stored Procedure can be selected a the time. And I need to all plus functions.
jorgedeoliveiraborges: I am going to try this on Monday.
Thank you.
SOLUTION
G Trurab Khan
7/15/2011
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
iscivanomar
7/16/2011
ASKER
Thank you all for this information, It is what I was looking for..
Your help has saved me hundreds of hours of internet surfing.
fblack61