asked on 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.
First, delete them and then create them again.
Thank you.
Microsoft SQL Server 2008Microsoft SQL Server 2005
Last Comment
iscivanomar
ASKER CERTIFIED SOLUTION
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.
Batch file to execute all files in a folder
SOLUTION
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.
SOLUTION
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.
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.
jorgedeoliveiraborges: I am going to try this on Monday.
Thank you.
SOLUTION
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.
ASKER
Thank you all for this information, It is what I was looking for..