Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2014-09-07 : 14:46:33
|
| Hi, i am looking for something i can use to automate Stored procedure creation or update. I found this that looks promising.http://blogs.lessthandot.com/index.php/datamgmt/datadesign/how-to-script-all-stored-procedures-in-a/This,as i see, will drop and recreate, so no alter procedure. Is this an ok script? If not, any other solutions in mind?Thanks.P.S. I am seeing an where is_ms_shipped = 0 , does this mean that it will only take out my own stored procedures?Thanks. |
|
|
TCCaines
Starting Member
1 Post |
Posted - 2014-09-09 : 16:48:15
|
| Seems I remember having a problem with permissions using the drop and create option. If you have granted any special permssions they are retained with alter. |
 |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2014-09-10 : 13:23:26
|
| You do not want to take out or modify an ms procedure. If your setup to use schemas then permissions should drive the process.djj |
|
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2014-09-12 : 03:57:15
|
| Hi. Was this for me?There is a switch in the script that specifies MS Sprocs or not and also i have cut down the procedures that declare "diagram" because they also come with my own procedures.Or you mean something else?Thanks. |
|
|
|
|
|
|
create script to auto update stroed procedures